| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Override normal VBA when clicking on a add-in (BEx) toolbar button
I have a toolbar with a "RefreshNow" button that I want to preempt so I can
do some extra steps. I have ID'd the toolbar and button object code as : commandbars("Business Explorer").Controls("RefreshNow") I have tried : commandbars("Business Explorer").Controls("RefreshNow").OnAction = MsgBox (for example), but this does not seem to work. I would like the preempt to work on all tabs of this workbook. For a procedure name, I tried "Sub RefreshNowButton_click()". Any Ideas would be greatly appreciated. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Toolbar has changed - how to return to normal | Excel Discussion (Misc queries) | |||
| Clicking hyperlink causes toolbar to show | Excel Discussion (Misc queries) | |||
| Spin Button to Change Label between Normal and BOLD | Excel Programming | |||
| Get info on toolbar button by clicking on it | Excel Programming | |||
| Delete a custom button by holding down the ALT key and dragging the button off the toolbar | Excel Programming | |||
![Ross @ CooperInd[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
