View Single Post
      02-21-2013, 07:46 PM   #12
Brigadier General
Hawkeye's Avatar

Drives: '07 Z4 si Coupe, '08 R6
Join Date: Aug 2007
Location: Iowa

iTrader: (0)

Garage List
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
2016 GMC Sierra SLT Z71 Premium Plus 4x4 K&N CAI Toyo G2 LT305/55R20