Hidding especific sheet

In a workbook I have 10 different sheets. I want to hide 3 different sheets and leave the other unhide. How can I do this?

worksheets("Sheet1").visible = xlSheetVisible
worksheets("Sheet2").visible = xlSheetHidden

etc.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"mik00725" <[email protected]> wrote in
message news:[email protected]...
>
> In a workbook I have 10 different sheets. I want to hide 3 different
> sheets and leave the other unhide. How can I do this?
>
>
> --
> mik00725
> ------------------------------------------------------------------------
> mik00725's Profile:
http://www.excelforum.com/member.php...o&userid=16169
> View this thread: http://www.excelforum.com/showthread...hreadid=556533
>

something like
for each ws in worksheets
if ws.name <> "diff1" and ws.name<> "diff2") then ws.visible=false
next ws

--
Don Guillett
SalesAid Software
[email protected]
"mik00725" <[email protected]> wrote in
message news:[email protected]...
>
> In a workbook I have 10 different sheets. I want to hide 3 different
> sheets and leave the other unhide. How can I do this?
>
>
> --
> mik00725
> ------------------------------------------------------------------------
> mik00725's Profile:
> http://www.excelforum.com/member.php...o&userid=16169
> View this thread: http://www.excelforum.com/showthread...hreadid=556533
>

Select the 3 sheets using CTRL + click on sheet tabs.

Format>Sheet>Hide


Gord Dibben MS Excel MVP

On Wed, 28 Jun 2006 10:57:19 -0500, mik00725
<[email protected]> wrote:

>
>In a workbook I have 10 different sheets. I want to hide 3 different
>sheets and leave the other unhide. How can I do this?