Button to run a macro

[billy2willy]

I would like to insert a button in cell a3 of my spreadsheet that will run a macro that makes the spreadsheet adjust to a certain print area. I have the macro already but I am not sure how to get the button into the cell to run the macro. Any ideas?

Thanks,

[Simon Lloyd]

Why have a button at all?, if you always want to use A3 just colour it add some text then in the worksheet module:

Please Login or Register  to view this content.

now whenever A1 is selected the macro will run!

[Portuga]

Alternatively, you create an autoshape from the draw menu, any gif/jpeg will also work and insert it in your sheet then right click on it and select "assign macro".