Macro hot button in Spreadsheet

W

watchtower

How can I create a hot button/key in my spreadsheet and attach a Macro that
will be available to everyone that opens it?

For example, I have a formatting macro on a shared file. When anyone opens
the file, I would like them to be able to click on a Macro button in some
cell, i.e. G1, which then runs the macro.

Thanks for the feedback.
Adam
 
G

Gary''s Student

First make the macro

Then in the wroksheet:

View > Toolbars > Forms

click the button form and draw the button on the worksheet.
Assign the macro as part of the drawing or right-click the button to asign
the macro
 
W

watchtower

Perfect! So easy!

Gary''s Student said:
First make the macro

Then in the wroksheet:

View > Toolbars > Forms

click the button form and draw the button on the worksheet.
Assign the macro as part of the drawing or right-click the button to asign
the macro
Click to expand...
 
C

CLR

I generally set up all my sheets up with about 8-10 rows frozen at the top.
Then I put my buttons in that area and that makes them available as the user
scrolls down the sheet.........particularly useful on large databases are a
pair of arrowheads marked "Go to bottom", and "Go to top"........I just use
ordinary drawing objects such as rectangles or ovals, and sometimes miniature
..jpg's to act as an icon. Then I just right-click and assign the macros to
them.

hth
Vaya con Dios,
Chuck, CABGx3
 
Top