Hi
I recently tried to add protection to my Excel document by selecting the 'Protect this workbook' feature from the Tools menu I clicked the 'Protect entirer workbook' option and entered a password. However, the next time I opened it I got a prompt asking if I wanted to enable Macros (Surely not even M$ Excels protection is entirely VBA macro based?!) even when I click yes I still just get direct access to the spreadsheets with no prompt. I have tried re-enabling the feature only for the same thing to (or not to) happen.
I am using Mac OS X 10.1.5 and Excel Version 10.0.0 (1316 build). Any ideas would be appreciated
Mark
I recently tried to add protection to my Excel document by selecting the 'Protect this workbook' feature from the Tools menu I clicked the 'Protect entirer workbook' option and entered a password. However, the next time I opened it I got a prompt asking if I wanted to enable Macros (Surely not even M$ Excels protection is entirely VBA macro based?!) even when I click yes I still just get direct access to the spreadsheets with no prompt. I have tried re-enabling the feature only for the same thing to (or not to) happen.
I am using Mac OS X 10.1.5 and Excel Version 10.0.0 (1316 build). Any ideas would be appreciated
Mark