Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi
I am using .OnAction in floating menubar and I want to know can you have the .OnAction call more then one subroutine? Example With Format .Caption ="Fomat a Sheet" .OnAction ="Format" End With I want to do something like below - that way since everything runs off this menubar I can keep the code more compact by putting in calls to Unlock and Lock before and after I do something to a sheet such as my format example I have tried a few different ways and have been unsuccessfull Example With Format .Caption ="Fomat a Sheet" .OnAction ="UnlockSht" "Format" "LockSht" End With |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Macro - onAction arguments | Excel Worksheet Functions | |||
Passing several parameters to OnAction property. | Excel Discussion (Misc queries) | |||
OnAction of Menu Bar with variable parameters | Excel Discussion (Misc queries) | |||
Timing problem with OnAction! | Charts and Charting in Excel | |||
OnAction | Excel Programming |