Deactivating worksheets

[Keri]

I want to deactivate a worksheets in Visual Basic...
Basiclly I want -- when the user clicks a button for two
worksheets to become inactive... I can't seem to find the
right code -- can anyone help??

Keri

 

[Tom Ogilvy]

do you mean hidden

Worksheets(Array("Sheet1","Sheet2")).Visible = xlHidden

 

[Keri]

Ok that works but how do you get it back?

-----Original Message-----
do you mean hidden

Worksheets(Array("Sheet1","Sheet2")).Visible = xlHidden

--
Regards,
Tom Ogilvy




.

 

[Tom Ogilvy]

Worksheets(Array("Sheet1","Sheet2")).Visible = xlsheetvisible