Problem with Personal.XLS and macros added to my toolbar

H

Harry Flashman

I have added numerous macros to my toolbar that are located in my
Personal.xls. Somehow thought these macros have become associated with
another workbook which is basically a duplicate of my Personal.xls
which is located in My Documents folder, called Create Folders.xls.
Thus when I try to execute one of these macros it opens Created
Folders.xls and execute the code stored there rather from my
Personal.Xls.
I caused this problem when I tried to write a macro to create Folders
based on a table in Excel, with which I have had only limited success.
Somehow one of my early efforts resulted in the accidental creation of
this duplicate version Personal.xls.
Is there an easy way I recan re-associate the macros in my toolbar
with Personal.xls rather than Create Folders.xls? Otherwise the only
other solution I can think would be to remove all the macros from my
tool bar and re-add them. Any advice about this would be greatly
appreciated.
 
D

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

Harry Flashman

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.htmhttp://www.rondebruin.nl/qat.htm -- For macros for all workbooks (saved as an
addin)
orhttp://www.rondebruin.nl/2007addin.htm







--

Dave Peterson- Hide quoted text -

- Show quoted text -

Thanks for tips Dave. I'll be sure to check them out. Sometime soon
I'll work out how to make xla file and store my macro's there. For the
time being I have just been adding them to a toolbar. I was able to
fix my probem by editing each macro (on the toolbar) to ensure that
they referenced my personal.xls and not the duplicate version of
personal.xls (which was created in error).
 

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

Top