 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / General Excel Questions / May 2008Macro button
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?  Signature--Chip Smith-- 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. SignatureRegards, Peo Sjoblom http://nwexcelsolutions.com >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? 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 [quoted text clipped - 6 lines] > > 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? 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. [quoted text clipped - 12 lines] > > > 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? 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. [quoted text clipped - 12 lines] > > > 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? |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.