HELP! Can't see worksheets

[Nogslaw]

I don't know what I did. I was testing a piece of code that displays a chart as a picture on a userform.

After I closed the userform, the Chart Window was open. I closed the Chart Window and my screen went blank, as if I had closed the workbook. The Excel background, toolbars, etc are still visible, but I can't see any of the sheets. I thought I had accidentally closed the workbook, so I tried to open it again. When that didn't seem to respond, I closed Excel. I then opened the workbook and I still can't see my worksheets. It is as if all of the sheets are hidden (which I know isn't supposed to be possible). I tried to use a sheet.visible command, but I get an error message that says "Method 'Sheets' of Object 'Global' failed".

Can anyone help??

Thanks in advance!

 

[dave3009]

First up what was the code you executed to cause the issue/

Second - you made a backup of your data, didn't you?

 

[mooseman]

Have you tried opening the file and using Windows/unhide... and select the file name?
I can hide all the sheets in a workbook and it looks like the file is closed.
I think if you hide all sheets in a workbook it hides the entire workbook.

 

[Nogslaw]

Mooseman - you nailed it. I never knew that existed.

Thanks again!