command button wizard

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

can i ask is there a command button wizard to e.g. add a macro to a command
button in excel 2003, if so can i add a macro to change autofilter values,
the worksheet is already autofiltered..
 
There is no wizard as such, but generally speaking the process is:
~ write or record your macro, and get it running to your satisfaction
~ open the tab that will hold the button
~ on the menu, click ~View ~Toolbars ~Forms; select the command button,
and place it on your sprdsht
~ assign your macro to the button; save the file
 
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

'Cannot insert object' message when I try to put a button on a worksheet 7
Access Automatically Send a notification email once a record is added 0
Macro Help 6
Macro 3
Placement of autofilter drop down menu? 6
Center Autofilter buttons 2
Command Button Excel 2007 4
AutoFilter 4

Back
Top