Solved: Get Tabs Back

[bopo]

HI

Recently I hide my tabs via some code, However I want the tabs back so I set the code to true, however this didnt bring the tabs back either, therefore I deleted the code and I still dont have tabs, help please

[Simon Lloyd]

Bopo, please supply the code you used to hide the sheets - reall it should be a simple as [VBA]Sheets("Sheet1").Visible = True[/VBA]

Regards,
Simon

[CBrine]

bopo,
Here's an extension of Simon's code, that cycles through each sheet in a workbook and makes it visible.

[vba]
sub UnHideAll()
Dim ws As Worksheet
For Each ws In ActiveWorkbook.Sheets
ws.Visible = xlSheetVisible
Next
End Sub
[/vba]

1. Open the vba editor by press Alt-F11.
2. Using the project explorer add a module to your project.
3. Using the Excel menu(not the vbe menu) select Tools...Macro.....Macro.
4. Select the macro from the dialogs list and press the run button.

HTH
Cal

[lucas]

bopo, if you would provide a link to the original thread so we didn't have to search for it this would be much simpler for us and you...............
http://www.vbaexpress.com/forum/show...6693#post86693
post # 4
[VBA]ActiveWindow.DisplayWorkbookTabs = False[/VBA]
If you set it to true then your tabs will re-appear.........
If all else fails go to tools - options....under the view tab check the sheet tabs checkbox....

[bopo]

Thanks, I needed to check the check box, thanks