I need help please trying to retain my custom macros assigned to toolbar buttons. Although it will make this a lenghty posting, I believe it would be useful to provide some specifics regarding my situation and my problem as follows:

On computer #1: over the years I have created dozens of buttons on several toolbars that are assigned to dozens of custom macros, using Excel 2003 on a winXP Pro platform. The macros appear to be contained within the file: Documents and Settings/username/Application Data/Microsoft/Excel/XLSTART/PERSONAL.xls, and the customized toolbars in the file: Documents and Settings/.../Excel/Excel11.xlb

On computer #2 I have just installed Excel 2003 on a win7 Pro platform, and would like to be able to use all of my macros and toolbars unchanged in the win7 environment. I used MS Office Tools' Save My Settings Wizard to save all office items (including the personal.xls and excel11.xlb files), transfered the .OPS file to comp#2, and used the same utility to restore .OPS file. The SMSW utility installed the PERSONAL.XLS file at C:\Users\username\AppData\Roaming\Microsoft\Excel\XLStart\PERSONAL.XLS and the xlb file at C:\Users\username\AppData\Roaming\Microsoft\Excel\Excel11.xlb

Here are the results of those actions on the win7 Pro system: all toolbars were created (retained) on the win7-Excel2003 platform and look identical to original on XP, and the list of custom macros is unchanged (all VBA modules are unchanged). However, clicking a custom toolbar button (e.g., to call the macro "fillpurple") does not call the assigned macro, and gives me the error message: The Macro "C:\Doc...\PERSONAL.XLS'!fillpurple' cannot be found.

I have tried to customize an existing assigned button to re-assign it to the appropriate macro. It appears to take, and thereafter works, as long as that worksheet is open... (e.g., if it cleck on the 'fillpurple' button, it will fill the active cell with purple pattern as desired.)

However, the re-assignment of the button to the proper macro apparently does not save when i close out the file. After re-opening, it behaves as it did before, i.e., after clicking it does not call the marco and gives the error message.

So, I need help. I'm only modestly comfortable and knowledgeable in working with VBA code, and all i want is to get the buttons to actually engage (call) the correct macro, and all of the macros are clearly visible on the win7Pro system. So why is it not working? It woud be fine if someone could point a relatively simple way to fix this (i don't mind looking like a simpleton, i just need to get this problem solved!!

Thanks in advance for any illumination that anyone on this list can shed to help me get back up to speed with Excel on my Win7P system. I have come to rely so heavily on these customized toolbars and buttons & macros that my productivity will take a dreadful plunge if i cannot get these working. Any recommendations?

My apologies for such a long post, but I'm hoping that someone with the knowledge to help me will appreciate the detailed background info I've tried to provide.