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.

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