Custom toolbar confusion

[cycle_simon]

This is probably trivial, but I'm new to Excel developoment and haven't been able to track down a solution in any documentation.

I have setup a custom toolbar in an application I have been working on and attached it to the workbook.

I have created and saved a number of versions of the workbook over time as I have added/debugged features. However, the assigned macros to the toolbar buttons keeps reverting back to a file name reference of an older version of the workbook. I.E.:

When I go to the button properties and open the assign macro dialogue box it will have:

c:/ ..../old version.xls!macro_name

instead of

c:/ ..../new version.xls!macro_name

I have deleted the toolbar from Excel11.xlb, but can't figure out where/how it is still finding these old references.

Any suggestions??

 

[SydneyGeek]

Toolbars and buttons do that in Excel, I think it's a bug.
The workaround is not to Save As when you want to copy the file. Instead, get out of Excel, use Windows Explorer to duplicate the file, then open it and make your data changes. The toolbars / buttons will reference the new file instead of the old.

Denis

 

[cycle_simon]

Thanks. I'll try that.