Macro button

[Guest]

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?

 

[Peo Sjoblom]

If your macro is stored in the personal.xls you can do
view>toolbars>customize, 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

 

[Guest]

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.

If your macro is stored in the personal.xls you can do
view>toolbars>customize, 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

 

[Laila]

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,

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.

 

[Laila]

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

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.