| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 . |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 . |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Deactivating a macro button | Excel Discussion (Misc queries) | |||
| Deactivating an Excel Warning | Excel Discussion (Misc queries) | |||
| Deactivating an embedded chart | Excel Discussion (Misc queries) | |||
| Deactivating Printing Message | Excel Programming | |||
| Error Msg Deactivating Code | Excel Programming | |||
![Keri[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
