how to make a sheet invisible?
i want to know how to make a sheet invisible. if the sheet is invisible how can i go to the sheet concerned? suppose i have a workbook with 4 sheets on it. they are named as blue,green,red and yellow. now i want to make the red sheet invisible what should i do? then if i want to make it visible what steps are to be taken. thanks. have a nice day.
click it's tab, select hide
click any tab, select unhide
Ben Van Johnson
Keep in mind that any-one who knows how to unhide the sheet, will be able to do so, it is just "not visible", it is not protected from being made visible
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
thanks a lotfor the tip. have a nice day.Originally Posted by protonLeah
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks