Macro button

E

E

A simple question, but I have never succesfully written macros before.
I have written two simple macros, one to filter for a value, and one to
remove the filter. I want to put two buttons on the top of the spreadsheet
which users can click to run the macro. Please can you advise.
 
J

Jarek Kujawa

Excel 2003

View->Toolbars->Forms

insert a button form on the sheet

then right click on it->Assign Macro->select relevant macro to bu run
by this button
 
J

Jarek Kujawa

i'm in my office - I use excel 2003 here

there shouldn't be a big difference, you would just need to look for
Toolbars/Forms on the ribbon in excel 2007
 
R

rogge

2007 allows inserting Form controls and Active X controls. At a very basic
level, the form controls can be assigned a macro where as the Active X
controls require their own sub-routine. Each type also has differing
properties which can be found on the web.
 
Top