Sorry, but when I save and close the worksheet, and re-open it, all the
passwords are in place again. Do you know what the
VB code it that is doing
this?
"Chip Pearson" wrote:
Sheet visibility can have on of three values: Visible, Hidden, and Very
Hidden. A sheet that is Very Hidden will not display in the list of hidden
sheets and cannot be made visible via any built-in Excel menu item or
command button. It can be made visible only via VBA code. Try something
like
Sub ShowVeryHidden()
Dim WS As Worksheet
For Each WS In ActiveWorkbook.Worksheets
If WS.Visible = xlSheetVeryHidden Then
WS.Visible = xlSheetVisible
End If
Next WS
End Sub
--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting
www.cpearson.com
(email on the web site)
"pgarcia" wrote in message
...
Ok, I got this spreed sheet from a coworker who is no longer here. Now,
look
at the spreed sheet, I see 4 tabs and found another 2 hiden. But the VB
code
shows 13 sheets. Where are the other sheets?