command button wizard
 

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..

command button wizard
 

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