Hidden Worksheets Reappear on Open

T

tonkind

When I open an Excel SS that I created (new or old) and had chosen t
"Hide" certain worksheets, the worksheets are all there. They do no
stay hidden. While I'm working in the file they are hidden, as soon a
I save it and then reopen it, they all reappear. I have tried openin
in safe mode, but still have the same problem. I have large files an
do not need to see all of the worksheets, but they won't stay hidden.
Any ideas?

Thanks.:confused
 
D

Dave Peterson

Can you try opening the workbook in safe mode, hiding the worksheets you want
hidden, then saving once more. Then close that workbook.

Now test it by reopening it in safe mode.

If the worksheets stay hidden this time, then it sounds like you have a macro at
work.

Look under the ThisWorkbook module for code that's trying to "help."
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top