ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   how to make a sheet invisible? (https://www.excelbanter.com/excel-discussion-misc-queries/448523-how-make-sheet-invisible.html)

sumesh56

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 worbook 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.

GS[_2_]

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
worbook 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.


FormatSheetHide/Unhide (XL2003 and earlier)

Home tab/Cells section:FormatVisibilityHide & Unhide (XL2007+)

--
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion




All times are GMT +1. The time now is 11:55 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com