subs and hidden tabs

[Guest]

I recently hid several tabs in my excel file (excel 2002), the next time I
opened this file, I tried to unhide one of the tabs, but could not. The
unhide command was not availabe, and I have made sure all the appropriate
check marks are there for show sheet tabs, etc. I have seen several
suggestions about subroutines, but I dont understand how you use one. Can
someone shed some light on my problem?

 

[Dave Peterson]

Maybe you protected the workbook.

Tools|Protection|Unprotect workbook
(You may need to supply your password)

 

[Don Guillett]

How did you hide them?

 

[Chip Pearson]

Mike,

Did you use code to hide the tabs? There are sheets that are xlSheetHidden,
which is the normal hidden mode. Then there are sheets that are
xlSheetVeryHidden. Sheets that are xlSheetVeryHidden cannot be made visible
via the Excel user interface. You must unhide them with code. In a standard
code module ("Insert" menu in VBA, "Module"), use code like

Sub UnhideAllSheets()
Dim WS As Worksheet
For Each WS In ThisWorkbook.Worksheets
WS.Visible = xlSheetVisible
Next WS
End Sub


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
(email address is on the web site)

 

[Chip Pearson]

Also, using code to unhide things seems ridiculous. Why do things have to
be
so difficult.

The entire point of xlVeryHidden is to make it difficult -- its "difficulty"
is its only reason to exist. If you want to hide sheets from users, use
Hide from the menu. But if you REALLY want to hide the sheet, use
xlVeryHidden. It keeps 99.9% of users from ever seeing the sheet.

If it were "easy", it would be worthless.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
(email address is on the web site)