View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Matt[_9_] Matt[_9_] is offline
external usenet poster
 
Posts: 2
Default .OnAction - Multiple Calls

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