MrExcel Publishing
Your One Stop for Excel Tips & Solutions

one click macro in menu bar.

Posted by Sandy on January 15, 2002 11:50 PM

How can I add an entry into the menu bar on opening a worksheet that has only one macro attached to it. I know how to do it with a rolldown menu but I do not want to role down anything. Just one click and the macro starts up.



Posted by Aron on January 16, 2002 12:52 AM


Assuming the macro will only be used on the sheet it's stored in: Right-click anywhere on your tool bars and select 'Customize.' Go to the 'Commands' tab and scroll down to 'Macros.' Click on the 'Custom button' and drag it to wherever you'd like on the tool bar.

Now right click your new button. Click in the Name box to give it a new name, click change button image to well, you get it, and click 'Assign Macro' to....

If the macro is stored in a worksheet and you want to use it on any worksheet, you may want to convert it to an addin. Send me the file if you'd like me to do it - just tell me where you want the button on the tool bar.