Hexen, Quake, Doom. Classic games that featured design that still works today.
Amid Evil is the First-Person Shooter We Need in 2018
Our Round-Up of the Seagate and Western Digital Line-Up
The Essential Xbox One X and PlayStation 4 Pro Add-On – An Ext
Suqare Enix goes all out with this definitive version of the critically acclaimed RPG. One that also pushes PC hardware, in one of the most visually impressive releases in a long while.
Final Fantasy XV: Windows Edition Review
A premium gaming monitor that offers exceptional performance for those with NVIDIA cards
LG 32GK850G QHD G-Sync Gaming Monitor Review
Locking / protecting an excel sheet
Gold Coast, Queensland
16 posts
I've got a sheet that i have developed heavily at work including a lot of macros and valuable code that i want to protect in case someone decides to leave and takes a copy of the sheet. so obviously i can't just put a password on the sheet cos he will need to use it every day. has anyone dealt with a similar situation?
08:59am 09/04/13 Permalink
08:59am 09/04/13 Permalink
6117 posts
If I understand your question correctly I think this will work:

Alt+F11 --> Tools --> VBA Project Properties --> Protection --> Lock + password, confirm password --> OK --> Close VBA --> Save --> Close and open workbook.
09:05am 09/04/13 Permalink
Gold Coast, Queensland
17 posts
Taggs - worked a treat thanks!

next question; is there a way to code in a time-bomb sort of thing whereby every x amount of time the sheet breaks (whether it simply doesn't work, or multiplies the quantities by y?

obviously by only locking VB the sheet can still function, you just can't see the code so i still need to get a resolution to if someone leaves and takes a copy of the sheet with them
09:16am 09/04/13 Permalink
Perth, Western Australia
1505 posts
Sounds dodgy, shouldn't you take that up with your employers or clients who are presumably paying you to develop said sheet?

Do you have a document control system with file auditing? Sounds like you need to be tracking that stuff.
09:57am 09/04/13 Permalink
Melbourne, Victoria
184 posts
Sounds very dodgy - however i'd love to help you screw over your employer.

You can put in todays date into the spreadsheet calcs - =TODAY()

then all your over calcs, make them something along the lines of IF =Today() < 09/10/2013 then "-" else (Calculation)

That should show all results until aftert that date.

P.S Eski is totally right tho - if you developed this during your companies time, it is actually not your property.
10:06am 09/04/13 Permalink
Brisbane, Queensland
11005 posts
At my job when there was a sort of power struggle for the company, and we knew one of the skill-less f**** in our office was a dirty little snitch because he believed the new leadership would put him in a management position, we fed him misinformation about code time-bombs in our infrastructure, then the company had to hire all these auditors to go through all our horrible code, recover deleted files off our hard drives, check all customer accounts for secret employee accounts, hahaaha what a circus they found nothing except I had removed the sata cables from my computer which made me look really suspicious, and another guy had totally forgotten he recently had a hard drive replaced and kept insisting they were wrong about their serial number theory.
10:20am 09/04/13 Permalink
Gold Coast, Queensland
18 posts
i'm not trying to do a dodgy here, i've had a suspicion that one of the guys on my team who had nothing to do with the development of the sheet is going to leave and i don't want him to take something with him that has taken me half a year to develop and is potentially worth a lot of money.

this has been very helpful thanks to all contributors.
11:28am 09/04/13 Permalink
Brisbane, Queensland
11006 posts
If it's worth a lot of money, then how come it's an excel spreadsheet?
Make it a webpage, only authorised people see the code that runs it, you control who can view or edit the data, and most importantly unless you're the one doing backups - you can't take anything with you when you leave.
Here's some news: lots of big organisations have spent s*** tonnes of money on MANAGING their RIGHTS with DIGITAL files, and the only way it ever works is if the super secret important bit is on a server.
11:39am 09/04/13 Permalink
11:39am 09/04/13 Permalink
AusGamers Forums
Show: per page
This thread is archived and cannot be replied to.