View Single Post
      02-21-2013, 06:46 PM   #12
Hawkeye
Brigadier General
 
Hawkeye's Avatar
 
Drives: '07 Z4 si Coupe, '08 R6
Join Date: Aug 2007
Location: Holland

Posts: 3,594
iTrader: (0)

Garage List
Quote:
Originally Posted by Hedges View Post
Is there a way to lock it down so they cannot even copy a file away onto their own USB or something on top of not able to copy paste cells / change cells?

Like having the excel file on a server, users can just double click to open but make it impossible to move a file , copy paste , change the cells in excel? They can screen capture it which is fine i dont mind that, just as long as the file stays where it is on the server and can only be viewed.
If it is going to be on network just password protect the file from anything and then set the network settings for that file so that nobody can copy it.


***Alternative solution****
What I would do if I was so paranoid is I would password protect all numbers and sheets so they could not be messed with in the file and I would put a macro in that checks the file path upon opening and if it is not the location that you put it (hardcoded in the macro) then erase all contents.

Really easy macro to write if you need help.

edit: If you do that make sure that you keep your master copy without that macro enabled. A simple connection error could possible make it not realize the filepath correctly.
__________________
2007 Z4 3.0si Coupe 6 MT Black Saphire Metallic PP SP Heated M Seats Clutch Stop Stubby
2008 R6 Raven Black GPR Steering Stabilizer Comp Werks FE Hotbodies Flush Mount Blinkers
2008 Nissan Titan XE King Cab Long Bed 4x4 Line-X
Hawkeye is offline   No_Country
0
Reply With Quote