 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / New Users / November 2006Hide sheet tabs?
Is there any way to hide sheet tabs? Thanks. Botman, Tools - Options - View. Sheet tabs.  SignatureEarl Kiosterud www.smokeylake.com ----------------------------------------------------------------------- > Is there any way to hide sheet tabs? > > Thanks. Tools | Options | View uncheck "Sheet tabs" > Is there any way to hide sheet tabs? > > Thanks. I should have clarified. I only want to hide SOME of the sheet tabs. Any way to do this? Thanks... You either see all the tabs at the bottom of the screen or you see none of them. But if you really meant that you wanted to actually hide the worksheets themselves... Select the sheets you want to hide. click on the first tab, and ctrl-click on the subsequent. then format|sheet|hide > I should have clarified. I only want to hide SOME of the sheet tabs. > > Any way to do this? > > Thanks... SignatureDave Peterson Nah... I really wanted to hide just some of the tabs within a single workbook. I didn't think it was possible, but I thought I would ask. If I do hide all the tabs, how do I jump to the different sheets in a workbook? Thanks. ctrl-pgup, ctrl-pgdn is one way to cycle through the worksheets. > Nah... I really wanted to hide just some of the tabs within a single > workbook. I didn't think it was possible, but I thought I would ask. [quoted text clipped - 3 lines] > > Thanks. SignatureDave Peterson " > Nah... I really wanted to hide just some of the tabs within a single > workbook. I didn't think it was possible, but I thought I would ask. You can - each worksheet has a Hidden property. I do it from VBA properties - there you can also make it so that they cannot be unhidden from within the Excel GUI (xlVeryHidden, or 2). I think robotman wants to keep the worksheets visible, but hide the associated tabs for a few worksheets. He actually means the little tab at the bottom of the window. > "robotman@gmail.com пиÑал(а): > " [quoted text clipped - 5 lines] > I do it from VBA properties - there you can also make it so that they > cannot be unhidden from within the Excel GUI (xlVeryHidden, or 2). SignatureDave Peterson I was thinking about that since replying - what is the purpose, if you don't mind me asking? " > I think robotman wants to keep the worksheets visible, but hide the associated > tabs for a few worksheets. He actually means the little tab at the bottom of [quoted text clipped - 8 lines] > > I do it from VBA properties - there you can also make it so that they > > cannot be unhidden from within the Excel GUI (xlVeryHidden, or 2). I have no idea. Robotman???? > I was thinking about that since replying - what is the purpose, if you > don't mind me asking? [quoted text clipped - 18 lines] > > > > Dave Peterson SignatureDave Peterson I'm getting confused. 8-) I have a workbook with about 10 worksheets in it. I want to hide 5 of the worksheets (and their associated tabs) to clean up the look of the workbook. I can't find the hidden attribute. For example: sheets("Sheet1").hidden = true Doesn't seem to work. Get's "Object doesn't support this property" error. Try Sheets("sheet1").visible = xlsheethidden ' or xlsheetveryhidden Lots of times, you can record a macro when you do it manually to get the code to use. From a previous response in this thread: But if you really meant that you wanted to actually hide the worksheets themselves... Select the sheets you want to hide. click on the first tab, and ctrl-click on the subsequent. then format|sheet|hide > I'm getting confused. 8-) > [quoted text clipped - 8 lines] > Doesn't seem to work. Get's "Object doesn't support this property" > error. SignatureDave Peterson |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.