If macros are disabled, there's nothing you can do to change they way it opens.

Maybe you can save the file with the worksheets hidden the way you want. Then
have your auto_open/workbook_open unhide the ones you want to see.



Eintsein_mc2 wrote:

Hi, what I was hoping to do is if the marcros are disable when the file
is opened all the worksheets are hidden except one with a message
saying to enable macros in which case this sheet would be hidden if the
macros were enable. TIA

--

Dave Peterson