View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Sheeloo Sheeloo is offline
external usenet poster
 
Posts: 793
Default 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?