Not allowing saving in XL

[isma786]

HI,

Is there a way to not allow users to save a spreadsheet when they use it.

 

[macropod]

Nothing that can't easily be defeated by any comptetent Excel user. You could use a macro to intercept the Save and Save As commands, but that can be defeated by:
a) copying worksheets to another workbook and saving that; or
b) holding down the Shift key while opening the workbook. This prevents the macro from running, while giving full access to all other workbook functions.

Cheers

 

[czarj]

Make it a read only file (password protect it to modify). Depending on your version go to Tools --> Options --> Security and choose a modification password and make it read only.

Now I'm guessing you just don't want people changing your spreadsheet??? If you want total security this won't work, people can still copy and paste it and make their own spreadsheet, but it will prtect yours!

~CzarJ

 

[isma786]

thanks guys