Macros do not remain assigned to toolbar buttons in new session of Excel

[MPerlman]

I am running Excel 2003. I have 16 Macros that I have created for one of my projects. They do remain from session to session.
I have assigned each Macro to a toolbar button. However, the Macros do not remain assigned to the buttons after I have closed a session of Excel 2003. The next session I must reassign them all over again. Clicking on a toolbar button in a new session produces a comment that the Macro cannot be found (see attached CannotBeFound.jpg), even though it clearly is there in the Macro list (see attached ClearlyExists.jpg).
I have also noticed that a Toolbar Button that I created for a certain Macro is missing from the Toolbar in a new session.

It appears that my Excel11.xlb is not being updated after the Macros are assigned. Or something else adverse is happening.

Thank you for reading and giving my problem your attention.

 

[RoryA]

Can you try running this?

Sub WhereIsPersonal()
msgbox workbooks("Personal.xls").path
end sub

and check if that path matches the one in the error message in your first picture.

 

[MPerlman]

Can you try running this?

Sub WhereIsPersonal()
msgbox workbooks("Personal.xls").path
end sub

and check if that path matches the one in the error message in your first picture.

How do i go about running that? Where do i type it in or paste it?

 

[RoryA]

Paste it into a module, click somewhere within the code and press f5

 

[MPerlman]

Can you try running this?

Sub WhereIsPersonal()
msgbox workbooks("Personal.xls").path
end sub

and check if that path matches the one in the error message in your first picture.

 

[MPerlman]

I have discovered a fix for my problem. It works. I don't know why it works and I really don't care as long as it continues to work.

Basically, I found two files Excel11.xlb on my hard drive. One in C:\Users\user\AppData\Roaming\Microsoft\Excel and the other in C:\Users\user\AppData\Roaming\Microsoft\Excel\XLSTART.

After I reassigned my buttons to the correct macros and closed Excel 2003, I copied the Excel11.xlb that was in C:\Users\user\AppData\Roaming\Microsoft\Excel onto my Desktop.

If I opened Excel 2003 normally, the buttons were unassigned as before. However, if I opened the Excel11.xlb file that I copied onto my Desktop (or opened it from C:\Users\user\AppData\Roaming\Microsoft\Excel) and Excel2003 opened with it, all the buttons were assigned properly. It did not work if I ran the Excel11.xlb file that was in XLSTART.

Before I bought my new computer with Windows 10, the naysayers were telling me , that Office 2003 will work on Windows 10, but Excel 2003 will not, and it is about time I progressed into the new versions of Office. Well, I wish to go on record that Office 2003 works in Windows 10, and so does Excel 2003. One just has to be a bit inventive.