Sheet tabs and other missing bits

[RichardMGreen]

Hi all

I've been passed a spreadsheet in 2007 format and the sheet tabs and row/column headings are hidden.
The options are ticked to show them but they aren't appearing.

Anyone any ideas on getting them back?

 

[VoG]

Maybe run this

Sub ShowOptionItems()
ActiveWindow.WindowState = xlMaximized
With ActiveWindow
    .DisplayHorizontalScrollBar = True
    .DisplayVerticalScrollBar = True
    .DisplayWorkbookTabs = True
End With
With Application
    .DisplayFormulaBar = True
    .DisplayStatusBar = True
End With
ActiveWindow.DisplayHeadings = True
End Sub

 

[bensonsearch]

If its a hidden sheet i right click a sheet(on the tab) that is there and select unhide then it asks unhide what. select it and done

 

[RichardMGreen]

@bensonsearch - the sheet itself isn't hidden, just the tab that shows the name and the row/column headers.

@VoG - Thanks, I'll give it a go.