Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default Hide selected worksheet tabs

Is there a way to hide selected worksheet tabs while leaving others
visible to the user. Excel 2003
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 709
Default Hide selected worksheet tabs

J.T. go to format sheet hide, to unhide go to format sheet unhide, you can
also hide the sheet with code or in the VBA editor under properties so you
can't see the sheet from the format unhide menu in code use something like
this

Sub Hidesheet()
Sheets("Sheet3").Visible = xlSheetVeryHidden
End Sub

Sub Unhidesheet()
Sheets("Sheet3").Visible =xlSheetVisible
End Sub


--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

"J. T. SYLVESTER SR." wrote in message
om...
Is there a way to hide selected worksheet tabs while leaving others
visible to the user. Excel 2003



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
hide a worksheet tabs tleehh Excel Worksheet Functions 4 October 20th 08 04:51 PM
hide tabs from view then lock tabs? slowboat Excel Discussion (Misc queries) 1 December 19th 07 07:06 AM
Printing Selected Sheet Tabs billbrandi Excel Discussion (Misc queries) 1 October 18th 07 12:36 AM
Hide Worksheet Tabs Beep Beep Excel Discussion (Misc queries) 2 September 20th 07 10:27 PM
Email selected tabs of spreadsheet? DrWilki Excel Discussion (Misc queries) 4 August 29th 07 01:27 PM


All times are GMT +1. The time now is 08:52 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"