PDA

View Full Version : [SOLVED] Security Level Macros - Protecting Workbook



spaz9876
06-29-2005, 08:54 AM
I looked on this site for a topic but couldnt find one.
How can I protect my workbook so that if someone has their macros/security level set too high, that the workbook wont open? Right now I have macros so that people with passwords can view certain sheets. If someone disables the macro, they can see all the sheets.

Thanks for any help!

Jacob Hilderbrand
06-29-2005, 09:48 AM
Well... The thing is... If macros are disabled then no code will run.

So, you can have all the sheets hidden, except for a splash screen. Then hide the splash screen and unhide the other sheets when the workbook is opened. Make sure to hide all the sheets on the before close event (and remember to save the workbook afterwards).

But this is not 100% secure. If the data is really sensitive, then do not use Excel.