Worksheets hidden

[NickCraig]

Hello

The sheets in my worksheet seem to have disappeared off the bottom of my worksheet so I can only access 1 sheet

Tried some things in advanced options but it seems to have ticked show all windows in the taskbar in display

Could it be something to do with moving files from one laptop to another with different XL versions?

Thanks
Nick

 

[jeffreybrown]

Hi Nick,

How about looking at the display options for this worksheet!

Show sheet tabs should be checked.

If not, could they have been hidden some how?

Here is some code to unhide all sheets

Sub UnhideAll()
    Dim ws As Worksheet
    Application.DisplayAlerts = False
    For Each ws In ActiveWorkbook.Worksheets
        ws.Visible = True
    Next ws
    Application.DisplayAlerts = True
End Sub

 

[NickCraig]

Thanks for the fast reply Jeff!

It's very odd

Show sheet tabs is ticked
And I've run your handy macro

And still the other sheets are not showing at all at the bottom of the screen, nor the one I am on. So I can't move between them....

Cheers
Nick

 

[jeffreybrown]

Hi Nick,

My other thought...

Select Alt + F11 to view the VBE.

On the left side of the screen you should see all the worksheets for this workbook.

Looks like here... http://www.rondebruin.nl/code.htm

Now select a sheet and then select F4 which on the bottom left of the screen will open the properties sheet.

Look under the Visble attribute and see what it says directly to the right.

One of either:
xlSheetVisible
xlSheetHidden
xlSheetVeryHidden

Alt + Q will close the VBE and return you to Excel

 

[NickCraig]

Thanks Jeff, that got it sorted!
Have a good day

 

[jeffreybrown]

You're welcome...Glad it worked out for you Nick