i wrote a macro for formatting a spreadsheet. is there a way to add a button
to excel like in a menu or button on the shortcut menu bar that when you
click on it from ANY workbook it will run this macro?
--
--Chip Smith--

If your macro is stored in the personal.xls you can do
viewtoolbarscustomize, select commands, scroll down to the macros and
select the custom button, then drag it unto your toolbar, there you can
right click it and change the button image, edit the image and assign your
macro.

--

Regards,

Peo Sjoblom

http://nwexcelsolutions.com



"Chip Smith" wrote in message
...
i wrote a macro for formatting a spreadsheet. is there a way to add a
button
to excel like in a menu or button on the shortcut menu bar that when you
click on it from ANY workbook it will run this macro?
--
--Chip Smith--

You can change the image to text that you specify. Right click on the button.
If you don't already have the customize box up, it will prompt you for that.
Then you would have to right click again.
Click on "Text Only". If you want text to show that is different from the
macro name, change the text in the "Name" box.

"Peo Sjoblom" wrote:

If your macro is stored in the personal.xls you can do
viewtoolbarscustomize, select commands, scroll down to the macros and
select the custom button, then drag it unto your toolbar, there you can
right click it and change the button image, edit the image and assign your
macro.

--

Regards,

Peo Sjoblom

http://nwexcelsolutions.com



"Chip Smith" wrote in message
...
i wrote a macro for formatting a spreadsheet. is there a way to add a
button
to excel like in a menu or button on the shortcut menu bar that when you
click on it from ANY workbook it will run this macro?
--
--Chip Smith--

Hi Patricia,

I tried this on a dummy macro just to see how it works. Now the button shows
up on every worksheet or excel file that I have. How do I delete this button?

Thanks,


"Patricia Shannon" wrote:

You can change the image to text that you specify. Right click on the button.
If you don't already have the customize box up, it will prompt you for that.
Then you would have to right click again.
Click on "Text Only". If you want text to show that is different from the
macro name, change the text in the "Name" box.

"Peo Sjoblom" wrote:

If your macro is stored in the personal.xls you can do
viewtoolbarscustomize, select commands, scroll down to the macros and
select the custom button, then drag it unto your toolbar, there you can
right click it and change the button image, edit the image and assign your
macro.

--

Regards,

Peo Sjoblom

http://nwexcelsolutions.com



"Chip Smith" wrote in message
...
i wrote a macro for formatting a spreadsheet. is there a way to add a
button
to excel like in a menu or button on the shortcut menu bar that when you
click on it from ANY workbook it will run this macro?
--
--Chip Smith--

Oh please disregard my previous message... found out how to delete the
button... Thanks!

"Patricia Shannon" wrote:

You can change the image to text that you specify. Right click on the button.
If you don't already have the customize box up, it will prompt you for that.
Then you would have to right click again.
Click on "Text Only". If you want text to show that is different from the
macro name, change the text in the "Name" box.

"Peo Sjoblom" wrote:

If your macro is stored in the personal.xls you can do
viewtoolbarscustomize, select commands, scroll down to the macros and
select the custom button, then drag it unto your toolbar, there you can
right click it and change the button image, edit the image and assign your
macro.

--

Regards,

Peo Sjoblom

http://nwexcelsolutions.com



"Chip Smith" wrote in message
...
i wrote a macro for formatting a spreadsheet. is there a way to add a
button
to excel like in a menu or button on the shortcut menu bar that when you
click on it from ANY workbook it will run this macro?
--
--Chip Smith--