one click macro in menu bar.

hi;

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.
HTH,
Aron