I have a file that dont want the user to to be able to use unless macros are
enabled. I have seen in past postings where people suggest using
xlVeryHidden and the file has one sheet visible stating that this file must
have macros running to work. Then if macros are enabled then the sheet opens
the worksheets to use and hides the message sheet. I do not see how that
works.

If a user enters the file with macros and with the VeryHidden sheets , but
with the macros running the Auto_Open has code to unhide the sheets. Now
when the user saves the file and exits the sheets are now visible so the next
user who may enter with Macros Security very high will be entering the file
with all the sheets visible. How do I fix this? What am I missing here?

Thank you,

Steven