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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to record a macro within a macro 9
Inserting cells (shift cells right) using macro 0
Command Button 2
Assign a Macro to a Command Button 1
attaching a macro to a control button in the Quick Access Toolbar 1
Run Macro If Cell have "x" value 0
Copy macro enabled button to another file 2
Excel Run macro upon cell edit 0

Back
Top