Macro button

  • Thread starter Thread starter E
  • Start date Start date
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.
 
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
 
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
 
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.
 

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

Pivot table macro filter data between yesterday and today (date+time) 0
Unable to assign macros to a new button in the current worksheet 1
Distribute macro to users 2
Macro + protection 8
Macro filter multiple criterea 5
Help with my macro 8
Macro files will not open 1
Use VBA Code to Assign Macro Buttons to use Different Queries for Source in a SubForm 0

Back
Top