Macro hot button in Spreadsheet

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

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
--
Gary''s Student
gsnu200703


"watchtower" wrote:

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

Perfect! So easy!

"Gary''s Student" wrote:

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
--
Gary''s Student
gsnu200703


"watchtower" wrote:

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

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





"watchtower" wrote:

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