Macro to run on button click

[rlkerr]

How can I make the following macro run on a button click instead of a change?

Please Login or Register  to view this content.

I tried just changing the

Please Login or Register  to view this content.

Please Login or Register  to view this content.

But it didn't work.

[GaidenFocus]

Are you using a user form? If not just create a button on your work sheet and tie it to the macro.

Please Login or Register  to view this content.

[GaidenFocus]

Or are you asking for it to run when ANY button is clicked? if you have control buttons for other macros just add a call command at the beginning or end of your macro depending on how you want it to work.

Please Login or Register  to view this content.

[rlkerr]

Thanks. It works fine. Thanks for you help.