View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Ken Johnson Ken Johnson is offline
external usenet poster
 
Posts: 1,073
Default Add a button to a macro

Hi Tom,

I like to use a button from the Forms toolbar.

Go View|Toolbars|Forms,then click on the little button icon on the
Forms Toolbar then click on your worksheet. The "Assign Macro" dialog
that appears should have your macro's name in the list of macros. You
can either double click its name or single click it then click the OK
button. After doing that your macro should run when you click the
button. To make any changes to the button's appearance just right click
it first.

I prefer this button to the Command Button from the Control Toolbar
because it works on PCs and Macs.

Ken Johnson