I need exactly what you said to do. BUT I do not have ANY choices when I click
on Macros in the Customize box. Any suggestions?

"Nigel" wrote:

You can create a custom toolbar by right clicking in an empty area of the
Excel toolbar area, choose the last item "Customize". Choose Toolbars from
the dialog and then click New, give your toolbar a Name. This appears as a
blank toolbar, now click Commands from the original dialog - scroll down to
Macro and click this item - drag Custom Button into your customer toolbar
(you might have to move the dialog to see it). On your new toolbar right
click the new icon just dropped in and select assign macro - choose the
macro from the list.

You will see when you right click the icon you can change a number of other
things - icon, text etc..... experiment with this as required. You can
attach your toolbar by dragging it to the main tool bar area, enable /
disable it using the customise option etc. If you exit Excel with the
toolbar enabled then it will appear next time you open Excel.

If the macro is required to act on a number of different files you open,
place your macro in your "Personal Workbook Area" it will then be available
whenever you open Excel - (of course only you will have this).
--
Cheers
Nigel



"owl527" wrote in
message ...

I have created a macro to process some data from a file that I receive
daily. How I do turn that macro into a button in the excel toolbar so
then I can just click the button each time I want to process a similar
file? I don't want to copy and paste the code everytime I get that
file. Please let me know. Thanks.


--
owl527
------------------------------------------------------------------------
owl527's Profile:
http://www.excelforum.com/member.php...o&userid=20916
View this thread: http://www.excelforum.com/showthread...hreadid=482127