code from menubars

[paulmcdonnell]

Hi guys,

******* QUICKIE *******

I can get a menu bar to run macros, but how do I attach more complex code to the action event of a menu bar. Can you do this?

CHeers
PAUL

 

[SimonC]

You can attach a function to a menu command or button.

Click View -> Toolbars -> Customise then right-click on the appropriate entry and select Properties from the menu.

In the Action property enter =FunctionName()
where "FunctionName" is, of course, the name of your function.

Simon