Whar type of Commandbutton?

If from Forms see Bob's reply.

If from Control Toolbox, place the macroname in your click event.


Gord Dibben MS Excel MVP

On Mon, 2 Nov 2009 13:25:01 -0800, Enoxy
wrote:

How can I assign a already assingned macro to a commandbutton.