Assign buttons on QAT
 

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...

Assign buttons on QAT
 

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

"xp" wrote:

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...

Assign buttons on QAT
 

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 wrote:

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...

--

Dave Peterson

Assign buttons on QAT
 

Got it. Thanks.

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


"Dave Peterson" wrote:

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 wrote:

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...

--

Dave Peterson