Macro name does not appear in button list

[scauser]

Hi,

When i went to create a macro button, the macro i just created does not appear in the Macro Name list.

Does anyone know why this would be?

Thanks!!

 

[PHV]

The macro must be a Public Sub without parameter.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[scauser]

Thanks PHV,

So i just type the word "Public" before the word "sub" in the code?

 

[JockMullin]

Hi, scauser

I've also seen that when installing a macro on another machine - have to execute the macro before it appears in the list.

Jock