View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Keri[_2_] Keri[_2_] is offline
external usenet poster
 
Posts: 9
Default 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



.