I have "inherited" a spreadsheet that was created in 1999. The sheet runs on an old version of office on the PC and is fully working, but move the sheets to another PC and errors occur. The sheet is for work and there is a custom toolbar on with some functions. There are two sheets, one is the main sheet and the other is a dummy in another workbook referenced from the main sheet, and this dummy workbook is the one with all the vba code. I dont know it's been done this way.
I have searched the code for the creation of the toolbar but I can only find code that shows the toolbar. This happens on opening the workbook. On clicking the toolbar buttons, an error dialog is shown (attached). It looks to be trying to save to a file? There seems to be a file name in the dialog. Using Ctrl + Shift + i on the dialog, gets the error message number in the bottom corner. I have tried googling it but nothing obvious is coming up.
I want to be able to edit the toolbar actions and buttons and also to back up the sheets and associated files incase the PC goes down (this is the only PC with it on). I have looked in Options - Addins and there are only the default ones when installing Office and again with no code that I can see that to create the toolbar, I am wondering where else to look and how the toolbar is being created.
Any ideas on what a next step could be?
Thanks
I have searched the code for the creation of the toolbar but I can only find code that shows the toolbar. This happens on opening the workbook. On clicking the toolbar buttons, an error dialog is shown (attached). It looks to be trying to save to a file? There seems to be a file name in the dialog. Using Ctrl + Shift + i on the dialog, gets the error message number in the bottom corner. I have tried googling it but nothing obvious is coming up.
I want to be able to edit the toolbar actions and buttons and also to back up the sheets and associated files incase the PC goes down (this is the only PC with it on). I have looked in Options - Addins and there are only the default ones when installing Office and again with no code that I can see that to create the toolbar, I am wondering where else to look and how the toolbar is being created.
Any ideas on what a next step could be?
Thanks