No worksheets are hidden, but none display

[ev77]

I have a workbook with macros which are able to access the data in the worksheets and function normally. However, if the workbook is opened (with or without any macros executing) no worksheets are displayed. What is displayed is a blank window with a small icon in the lower left of the window where worksheets are normally displayed. (See attached screen capture.)
The "Visible" property of each sheet is -1 which means that the sheet is visible.

If I open the "View" tab, almost everything is greyed out including "Window/New Window".

I have no way to see or access the worksheet data except via the macros.

Any help will be MUCH appreciated. Thanks!

[skywriter]

Can you attach the workbook?

View Pic

[AlphaFrog]

It looks like the workbook window is minimized. Can you double-click on the Excel icon in the lower left?

This link offers a few suggestions though I'm not sure if any of them apply in this case.
https://support.office.com/en-nz/art...c-f1b381185e48

[ev77]

Using macros, I deleted all of the data from the worksheets, and removed the workbook's password. The resulting file has the same problem and is the one I attached.

The really weird thing is that when I went to upload the file to this site, the preview showed some of one of the worksheets.
When I saw that, I tried emailing a copy of the file to myself using Thunderbird. Its preview also showed the same thing, but the emailed file still contains the problem.

Thanks again for any help.

[skywriter]

It opened fine for me. I have three sheets visible. Main, Data and CheckSheet.
I would suggest you open a new window and see if that works.
I have 2010, I go to the View tab and choose new window. Maybe that will work for you. I also see in the visual basic editor when I click on each sheet name and view the properties tab that you have sheet LB hidden. Maybe set that property to visible and save and reopen, you never know.

[_Julia_]

Hello there!

This looks like something I encounter way too often. Try this: Go up to View, then Arrange All, hit OK. (It doesn't matter which arrange option is selected for what you're trying to do.)

[AlphaFrog]

I can see them too.

This will maximize the workbook window. Give it a shot.

Please Login or Register  to view this content.

[skywriter]

Here's the sheet back saved with a new name and window and no hidden sheets.

[ev77]

Thanks for your reply. Double clicking on the icon makes excel want to close the workbook after asking me if I want to save changes. The suggestions on the web page do not apply to this situation.

[ev77]

When I select "View" all items in "Window" are greyed out except for "Arrange All" and "Hide" . Neither of these appears to do anything when selected.

[ev77]

Well doing ActiveWindow.WindowState = xlMaximized works - sort of. The window becomes visible with all my worksheets - BUT when I save the workbook and close then reopen it the worksheets are not displayed. I have to run that like of code each time I open the workbook.

SOLVED: A macro had left ActiveWindow.WindowState = xlMinimized in effect when Excel was closed. Excel remembered that on the next open, even is it had been saved as an .xlsx (thus - having no macros). Ensuring ActiveWindow.WindowState = xlMaximized on workbook close solves the problem. THANKS EVERYONE for all the help.!

[skywriter]

Thanks for sharing that.

Please click the Thread Tools drop down box above your first post and choose solved.