is there a shortcut to macros

[Roger Dodger]

Hi All,

Is it possible to create a button in a cell ( maybe A1) that when I click on
it, will run a pre-recorded Macro?


Thanks

Kevin

 

[Pete_UK]

Yes, look at the response from Ron de Bruin in this thread:

http://groups.google.com/group/micr...nk=gst&q=button+to+run+macro#815a5e9265fcb3e5

It has changed a bit with XL2007, but it's the same basic approach.

Hope this helps.

Pete

 

[Roger Dodger]

Yeah baby

I love it!!!

Yes, look at the response from Ron de Bruin in this thread:

http://groups.google.com/group/micr...nk=gst&q=button+to+run+macro#815a5e9265fcb3e5

It has changed a bit with XL2007, but it's the same basic approach.

Hope this helps.

Pete

 

[Pete_UK]

I suppose that means you got it to work, Roger - thanks for feeding
back.

Pete