#1   Report Post  
Ankur
 
Posts: n/a
Default hide worksheet

is there any way to hide worksheets in a workfile for eg - i have to hide 5
to 8 worksheet in a workfile consisting of 10 worksheet.
  #2   Report Post  
Doug Kanter
 
Posts: n/a
Default


"Ankur" wrote in message
...
is there any way to hide worksheets in a workfile for eg - i have to hide
5
to 8 worksheet in a workfile consisting of 10 worksheet.


Yes, there is, and it's simple & clearly labeled. Explore the Excel menus
until you find the word "Hide". Or, press F1 for the Help system and search
for the word "Hide".


  #3   Report Post  
Alan
 
Posts: n/a
Default

Yes there is, on the top toolbar, Format Sheet Hide. If you want to
prevent users unhiding them, password protect the workbook.
Note that Excel protection is weak and easily overcome by an experienced
user who has the will to do so,
Regards,
Alan.
"Ankur" wrote in message
...
is there any way to hide worksheets in a workfile for eg - i have to hide
5
to 8 worksheet in a workfile consisting of 10 worksheet.



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 so that a macro can still find it frendabrenda1 Excel Worksheet Functions 1 June 17th 05 04:30 PM
Hide AutoShapes On Excel Worksheet Dave Y Excel Worksheet Functions 5 June 12th 05 04:26 AM
How do I automatically hide columns in a worksheet based on a cell value? dkhedkar Excel Worksheet Functions 1 March 5th 05 12:20 AM
how to hide section of worksheet based on a condition (e.g. tick . kitepuppet Excel Discussion (Misc queries) 2 March 4th 05 06:30 PM
How do I hide a worksheet in Excel and use a password to un-hide . Dchung Excel Discussion (Misc queries) 3 December 2nd 04 06:24 AM


All times are GMT +1. The time now is 04:59 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"