Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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... |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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... |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can I assign button/buttons to XL 2007 by Macro for different | Excel Worksheet Functions | |||
Assign different buttons by Macro | Excel Discussion (Misc queries) | |||
How to assign different Linked cells to option buttons | Excel Programming | |||
How do you assign macro's to new menu with buttons on Auto_open? | Excel Programming | |||
How do you assign macro's to new menu with buttons on Auto_open? | Excel Programming |