Deactivating worksheets

Keri · Aug 31, 2004

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 · Aug 31, 2004

do you mean hidden

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

Keri · Aug 31, 2004

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 · Aug 31, 2004

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