subs and hidden tabs
 

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?

subs and hidden tabs
 

Maybe you protected the workbook.

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

Mike wrote:

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

subs and hidden tabs
 

How did you hide them?

--
Don Guillett
SalesAid Software

"Mike" wrote in message
...
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?

subs and hidden tabs
 

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)


"Mike" wrote in message
...
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?

subs and hidden tabs
 

All I did was highlight the tabs I wanted to hide, and went to the pull down
hit "hide". No codes, nothing special, I am no programmer. I did not protect
anything that I am aware of.

"Chip Pearson" wrote:

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)


"Mike" wrote in message
...
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?

subs and hidden tabs
 

ALso, using code to unhide things seems ridiculous. Why do things have to be
so difficult. I have no idea how to use the code listed below.

"Mike" wrote:

All I did was highlight the tabs I wanted to hide, and went to the pull down
hit "hide". No codes, nothing special, I am no programmer. I did not protect
anything that I am aware of.

"Chip Pearson" wrote:

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)


"Mike" wrote in message
...
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?

subs and hidden tabs
 

"Mike" wrote in message

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)


"Mike" wrote in message
...
ALso, using code to unhide things seems ridiculous. Why do things have to
be
so difficult. I have no idea how to use the code listed below.

"Mike" wrote:

All I did was highlight the tabs I wanted to hide, and went to the pull
down
hit "hide". No codes, nothing special, I am no programmer. I did not
protect
anything that I am aware of.

"Chip Pearson" wrote:

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)


"Mike" wrote in message
...
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?