sheet tabs disappear
 

I have got a sheet from the internet,when I open it ,I did not found any
sheet tabs. it is very interesting for me to design some sheet in this way.
so people can not click the tab. When I try it by myself,I found I can not
hide all the tabs by righ click the tab -Hide

How to hide all the tabs?

sheet tabs disappear
 

toolsoptionsview

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Li Jianyong" wrote in message
...
I have got a sheet from the internet,when I open it ,I did not found any
sheet tabs. it is very interesting for me to design some sheet in this
way.
so people can not click the tab. When I try it by myself,I found I can not
hide all the tabs by righ click the tab -Hide

How to hide all the tabs?

sheet tabs disappear
 

As far as I know you must have at least one sheet visible...
Can you share the link to the file?

Try
Sub hideTabs()
For Each ws In Sheets
On Error Resume Next
ws.Visible = False
Next
End Sub

"Li Jianyong" wrote:

I have got a sheet from the internet,when I open it ,I did not found any
sheet tabs. it is very interesting for me to design some sheet in this way.
so people can not click the tab. When I try it by myself,I found I can not
hide all the tabs by righ click the tab -Hide

How to hide all the tabs?

sheet tabs disappear
 

My excel is 2007 version,I don't found the toolsoptionsview



"Don Guillett" wrote:

toolsoptionsview

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Li Jianyong" wrote in message
...
I have got a sheet from the internet,when I open it ,I did not found any
sheet tabs. it is very interesting for me to design some sheet in this
way.
so people can not click the tab. When I try it by myself,I found I can not
hide all the tabs by righ click the tab -Hide

How to hide all the tabs?

sheet tabs disappear
 

I don't remember the link. if you want,I can send you by email.

I read the code you provided,it seems to hide all the sheet, not sheet.tab



"Sheeloo" wrote:

As far as I know you must have at least one sheet visible...
Can you share the link to the file?

Try
Sub hideTabs()
For Each ws In Sheets
On Error Resume Next
ws.Visible = False
Next
End Sub

"Li Jianyong" wrote:

I have got a sheet from the internet,when I open it ,I did not found any
sheet tabs. it is very interesting for me to design some sheet in this way.
so people can not click the tab. When I try it by myself,I found I can not
hide all the tabs by righ click the tab -Hide

How to hide all the tabs?

sheet tabs disappear
 

Try Don's suggestion
Excel 2007 navigation;
OFFICE BUTTON - Excel Options - Advanced - Display options for this
workbood - Show sheet tabs
Clear the check box

"Li Jianyong" wrote:

I don't remember the link. if you want,I can send you by email.

I read the code you provided,it seems to hide all the sheet, not sheet.tab



"Sheeloo" wrote:

As far as I know you must have at least one sheet visible...
Can you share the link to the file?

Try
Sub hideTabs()
For Each ws In Sheets
On Error Resume Next
ws.Visible = False
Next
End Sub

"Li Jianyong" wrote:

I have got a sheet from the internet,when I open it ,I did not found any
sheet tabs. it is very interesting for me to design some sheet in this way.
so people can not click the tab. When I try it by myself,I found I can not
hide all the tabs by righ click the tab -Hide

How to hide all the tabs?

sheet tabs disappear
 

thanks . it works as what I want now.

"Sheeloo" wrote:

Try Don's suggestion
Excel 2007 navigation;
OFFICE BUTTON - Excel Options - Advanced - Display options for this
workbood - Show sheet tabs
Clear the check box

"Li Jianyong" wrote:

I don't remember the link. if you want,I can send you by email.

I read the code you provided,it seems to hide all the sheet, not sheet.tab



"Sheeloo" wrote:

As far as I know you must have at least one sheet visible...
Can you share the link to the file?

Try
Sub hideTabs()
For Each ws In Sheets
On Error Resume Next
ws.Visible = False
Next
End Sub

"Li Jianyong" wrote:

I have got a sheet from the internet,when I open it ,I did not found any
sheet tabs. it is very interesting for me to design some sheet in this way.
so people can not click the tab. When I try it by myself,I found I can not
hide all the tabs by righ click the tab -Hide

How to hide all the tabs?