Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Make custom buttons point to local macros always
I created a custom toolbar with custom buttons that run macros in my workbook.
I attached the toolbar with the workbook and saved the file. If I copy that file to another file name or move the file to another directory, the custom buttons still point to the original file and its macros. How can I make the custom buttons refer always to the local macros (which I may have modified/improved from the original ones)? Thank you. Fabian |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Make custom buttons point to local macros always
Saved from a previous post:
Your life will become much simpler if you include code to create the toolbar when the workbook is opened and include code to destroy the toolbar when the workbook is closed. For additions to the worksheet menu bar, I really like the way John Walkenbach does it in his menumaker workbook: http://j-walk.com/ss/excel/tips/tip53.htm Here's how I do it when I want a toolbar: http://www.contextures.com/xlToolbar02.html (from Debra Dalgleish's site) In xl2007, those toolbars and menu modifications will show up under the addins. And if you use xl2007: If you want to learn about modifying the ribbon, you can start at 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 Fabian wrote: I created a custom toolbar with custom buttons that run macros in my workbook. I attached the toolbar with the workbook and saved the file. If I copy that file to another file name or move the file to another directory, the custom buttons still point to the original file and its macros. How can I make the custom buttons refer always to the local macros (which I may have modified/improved from the original ones)? Thank you. Fabian -- Dave Peterson |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Make custom buttons point to local macros always
Thank you very much Dave! That do the job.
Fabian "Dave Peterson" wrote: Saved from a previous post: Your life will become much simpler if you include code to create the toolbar when the workbook is opened and include code to destroy the toolbar when the workbook is closed. For additions to the worksheet menu bar, I really like the way John Walkenbach does it in his menumaker workbook: http://j-walk.com/ss/excel/tips/tip53.htm Here's how I do it when I want a toolbar: http://www.contextures.com/xlToolbar02.html (from Debra Dalgleish's site) In xl2007, those toolbars and menu modifications will show up under the addins. And if you use xl2007: If you want to learn about modifying the ribbon, you can start at 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 Fabian wrote: I created a custom toolbar with custom buttons that run macros in my workbook. I attached the toolbar with the workbook and saved the file. If I copy that file to another file name or move the file to another directory, the custom buttons still point to the original file and its macros. How can I make the custom buttons refer always to the local macros (which I may have modified/improved from the original ones)? Thank you. Fabian -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
make custom buttons for macros on quick access bar excel 2007 | Excel Discussion (Misc queries) | |||
make custom buttons for macros on quick access bar excel 2007 | Excel Discussion (Misc queries) | |||
Two questions, how do I disable ver 4 macros and how do I make radial buttons like this? | Excel Discussion (Misc queries) | |||
Two questions, how do I disable ver 4 macros and how do I make radial buttons like this? | Excel Worksheet Functions | |||
how to create buttons which point to other worksheets? | Excel Discussion (Misc queries) |