View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default 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