Hide worksheets if macros are disable

[Eintsein_mc2]

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]

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.

 

[Ross]

I just thought of a different way to hide your sheet, that doesn't involve
macros at all. How about scrolling down to say row 200 and over to about AA
and make cell AA200 the upper left hand corner of a given sheet. Then go
back to A1 and pick a cell -- your choice, say B12 for example. Then put
any text in that cell, format the text color so it is the same as the
background of the sheet, and then right-click and assign a hyerlink that
puts the upper left corner of your spreadsheet at the upper left corner of
the screen. You would need to go to A1 each time you saved OR you could
have a macro do that for you.