Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Enable toolbar button in one specific worksheet
Hi,
I have a five-worksheet excel book and I need to disable a button in a custom toolbar if the user is not in one specific worksheet. I know how to disable the button but I can't figure out how to trigger the event when the user switches worksheets. any ideas? Thanks -- JuanK |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Enable toolbar button in one specific worksheet
Private Sub Worksheet_Activate()
'your code End Sub 'This is worksheet event code, which means that it needs to be 'placed in the appropriate worksheet code module, not a standard 'code module. To do this, right-click on the sheet tab, select 'the View Code option from the menu, and paste the code in. -- HTH Bob Phillips "JuanK" wrote in message ... Hi, I have a five-worksheet excel book and I need to disable a button in a custom toolbar if the user is not in one specific worksheet. I know how to disable the button but I can't figure out how to trigger the event when the user switches worksheets. any ideas? Thanks -- JuanK |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can I move a button from toolbar to a worksheet? | Excel Discussion (Misc queries) | |||
How do I put a toolbar button into a worksheet? | Excel Worksheet Functions | |||
Displaying Custom Toolbar in Specific Worksheet | Excel Programming | |||
how to enable / disable customised button on toolbar | Excel Programming | |||
Macro to enable or visible on specific worksheet only | Excel Programming |