Macro button
 

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.

Macro button
 

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


On 14 Sty, 13:43, E wrote:
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.

Macro button
 

I use Office 2007 - does this make a difference (before I start)?

"Jarek Kujawa" wrote:

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


On 14 Sty, 13:43, E wrote:
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.

Macro 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


On 14 Sty, 14:02, E wrote:
I use Office 2007 - does this make a difference (before I start)?



"Jarek Kujawa" wrote:
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

On 14 Sty, 13:43, E wrote:
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.- Ukryj cytowany tekst -

- Poka¿ cytowany tekst -

Macro button
 

I've done it! I had to look on the Help menu but I found how to do it. Many
thanks.

"Jarek Kujawa" wrote:

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


On 14 Sty, 14:02, E wrote:
I use Office 2007 - does this make a difference (before I start)?



"Jarek Kujawa" wrote:
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

On 14 Sty, 13:43, E wrote:
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.- Ukryj cytowany tekst -

- Pokaż cytowany tekst -

Macro button
 

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.

"E" wrote:

I've done it! I had to look on the Help menu but I found how to do it. Many
thanks.

"Jarek Kujawa" wrote:

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


On 14 Sty, 14:02, E wrote:
I use Office 2007 - does this make a difference (before I start)?



"Jarek Kujawa" wrote:
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

On 14 Sty, 13:43, E wrote:
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.- Ukryj cytowany tekst -

- Pokaż cytowany tekst -

Macro button
 

welcome
thks for the feedback
;-)

On 14 Sty, 14:42, E wrote:
I've done it! I had to look on the Help menu but I found how to do it. Many
thanks.