I'm unclear from your description of what is required.
Sounds like an instance where one might make (on file closure) all sheets xlSheetVeryHidden except one. That one "entry sheet" has a message along lines "macros must be enabled for this workbook to function".
On file opening, an autorun routine hides this "entry sheet" and reveals the worksheets you want exposed. And if the file is opened without macros enabled, the autorun macro obviously won't run & this entry sheet is all that the user sees. VBA password protected, BTW.
If that makes sense? Again, I'm not sure if this is what you're after...
Is there something better than the built in VBA Password Protection?
Yes. However, I don't know about it. Suggest you start a new thread, 'cause this is really a new question and it will be seen by more people that way. (I understand one approach is to use Visual Basic and create a COM add-in. These are little more than familiar words to me; I've read this sort of answer but personally am unfamiliar with it.) Regards, Fazza
if you digitaly sign your work book using the tools menu in vba window and when you open your work book you tick "always trust this publisher" then the work book will open with marcos enabled every time (see my post on opening access runtime withoit the permissions box)