Run a Macro by clicking a cell

[Endorphin]

Hi all need a little help with this one.

I have created macros to change pivot table data to specific settings.
I also have a list of items that are relevant to that data, How can i run one of the Macros by clicking on the heading in the list.

Any Ideas

Neil

[Carim]

Hi,

By placing a command button in your spreadsheet ...


HTH
Carim

[Endorphin]

Many Thanks

I dont know how to do it but will have a look through the help files.

[Carim]

Well ..

View ToolBars Control ToolBox
Click on command button
view code
to add
Application.Run("yourmacro")

that's it ...

HTH
Carim

[Endorphin]

Brilliant.....

Worked a treat,

Neil

[Carim]

Glad your problem's fixed

Thanks for the feedback

Carim