Is it possible to not allowing saving an Excel (.xls) file? (Should also work in Numbers on OSX)

link|improve this question
2  
It would help is you further explain the situation. Do yo mean protecting an existing spreadsheet from change? – surfasb Mar 1 '11 at 12:33
feedback

migrated from stackoverflow.com Mar 1 '11 at 12:19

This question came from our site for professional and enthusiast programmers.

2 Answers

As in change it so it is read only, you mean? You can do that with a password if I'm not mistaken.

But disallow saving - I don't see the point - someone could always copy the file.

link|improve this answer
feedback

You could have a macro on the Before_Save event, but circumventing it only means disabling macros.

       ThisWorkbook.Close savechanges:=False

If you forced macros to be enabled to even view the content that might help, but won't ensure not saving. Chip Pearson's site has some interesting TimeBombRegistry code you might adapt

link|improve this answer
feedback

Your Answer

 
or
required, but never shown