Assign buttons on QAT

[xp]

I have a file named: AutoOpenMacros.xlsm

The above named file has been placed into a folder named: XLAutoOpen

I pointed Excel to use the above named folder as the "Startup" folder to
open all files in that folder when Excel is opened.

Now, I want to assign a few macros to custom buttons on the Quick Access
Toolbar (QAT). But, I can't figure out how to make the assignment, how do I
do this?

Thanks in advance...

 

[Eduardo]

Hi,
go to the custom button, right click on the mouse, assign macro, choose the
macro to assign

 

[Dave Peterson]

I'd start on Ron de Bruin's site:
http://www.rondebruin.nl/ribbon.htm
http://www.rondebruin.nl/qat.htm -- For macros for all workbooks (saved as an
addin)
or
http://www.rondebruin.nl/2007addin.htm

 

[xp]

Got it. Thanks.

Save file as an XLSB and it has to be a "Public Sub" to become visible...