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.




Dave Peterson

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:

Here's how I do it when I want a toolbar:
(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: -- For macros for all workbooks (saved as an


Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question