Button control to run a macro?

  • Thread starter Thread starter Dick Prenovost
  • Start date Start date
D

Dick Prenovost

I am sure there is some way of doing this, but the "Help" feature has the
solution pretty well hidden . . .
I am trying to create a spreadsheet with a button control that will "show
all" lines once the user has finished using a line selected by using a
filter.
I know how to add a button, I know how to record a macro, I just can't
figure out how to run the macro when the button control is clicked. Any
Help?
Thanks,
Dick Prenovost
 
Hi

When you add a button from Forms toolbar into worksheet, you are asked for
assigning the macro attached to this button.
 
If you have created the macro and placed the button on the sheet you
should be able to assign a macro by right clicking the button and use
'Assign a Macro' from the drop down menu.

Hope this helps

Mike
 
Back
Top