| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel Tabs continuously disappear | Excel Discussion (Misc queries) | |||
| tabs are missing even though 'tools-options-view-sheet tabs' ok? | Excel Worksheet Functions | |||
| Hiding Rows makes entire sheet disappear | Excel Discussion (Misc queries) | |||
| Shared folder - tabs disappear while saving | Excel Worksheet Functions | |||
| Sheet tabs disappear sometimes in Internet Explorer | Excel Discussion (Misc queries) | |||
Hybrid Mode
