Security Level Macros - Protecting Workbook

[spaz9876]

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]

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.