We take the latest South Park joint for a jaunt on the toilet... will it flush?
South Park: The Fractured But Whole Review!
We chat with the game director and creative head of Machine Games about the upcoming title where killing Nazis is all the rage.
A Happy Ending Filled with Nazis – Wolfenstein II Interview!
From the creators of Payday comes a new action title where you get to steal back treasure from Nazis.
Win a Copy of RAID World War II on PS4
Locking / protecting an excel sheet
uhohh
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
system
Internet
--
08:59am 09/04/13 Permalink
taggs
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
uhohh
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
eski
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
DoCZero
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
thermite
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
uhohh
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
thermite
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
system
Internet
--
11:39am 09/04/13 Permalink
AusGamers Forums
Show: per page
1
This thread is archived and cannot be replied to.