Create a button and assign a macro to it?

[randy__6]

I've written a macro and have been using it with the ctrl+ shortcut. Now I would like to create a button and assign the macro to it. How do I do that?

 

[Smitty]

Welcome to the Board!

You can draw a button from the Forms toolbar. When you're done you'll get a menu. Chose the Assign Macro option and select your macro from the list.

Hope that helps,

Smitty

 

[randy__6]

Tried that...didn't work. Then I restarted excel and tried it again...worked.

Thanks