Deactivating worksheets
 

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

Deactivating worksheets
 

do you mean hidden

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

--
Regards,
Tom Ogilvy

"Keri" wrote in message
...
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

Deactivating worksheets
 

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

"Keri" wrote in
message
...
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


.

Deactivating worksheets
 

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

--
Regards,
Tom Ogilvy

"Keri" wrote in message
...
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

"Keri" wrote in
message
...
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


.