How to get custom toolbar references to macros in personal.xls to save ?

D

dcwilkie

Here's my situation:
Switched to Mac from PC and brought over my PERSONAL.XLS and
EXCEL11.XLB files. Put them both in Microsoft Office
2004:Office:Startup:Excel location. When I start Excel, my custom
toolbars show up and personal.xls shows up in hidden, so okay there.
When I click on a custom toolbar button, naturally, the link to the
macro is wrong (because it is referencing the old Windows location).
So I go to Customize and link it the hidden personal.xls and then it
works fine ... HOWEVER, after I close Excel and reopen it, even though
I've accepted to save personal settings, the old macro link comes back
and the button does not work. In other words, my changes to the toobar
are not saving. How can I fix this problem? Thanks!
 

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

Similar Threads

Custom toolbar button for search and replace 1
Error After Copying Excel 2003 Macros and Toolbars from Windows Vistato Windows 7 1
My custom number list doesn't seem to save? 1
How can I save directly into the same folder every time in Office 365 / Windows 10? 0
ISO best steps to export (import) all from Outlook 2003 to Outlook in MS 365 0
Can I mass-change macro paths of tool buttons? 15
Problem with Personal.XLS and macros added to my toolbar 3
Relative Macro Assignment in Custom Menus 1

Top