Buttons for Macros

  • Thread starter Thread starter Ainsley
  • Start date Start date
A

Ainsley

Hi, Ive created some simple Macros that print sheets in my workbook.
Which is all fine, but I will be sending the spreadsheet out to people
who will not have a clue how to use a macro. Currently Im using Ctrl+x
to do it, but............

I want to create a button on the worksheet that they can press with
their mouse to activate the Macro. Is this possible - Im sure Ive seen
it somewhere.


Thanks.
 
goto the forms tool bar and click on the button
draw the button anywhere on the spreadsheet, assign the macro to it
you can change what macro is assigned to it by right clicking on it

You can also assign macros pictures and images, right click on th
image and assign a macro to i
 
Back
Top