Macro storage location

Hi DanBlum;

Obviously the macros assigned to the buttons have the old filename in them.

I don't know if this will work on menu buttons, but you can try in the menus EDIT>LINKS. If there are no links to other files the "LINKS" option will be disabled (grayed out). If it's enabled then select the file that some links are pointing to and click "Change Source", then just select the workbook you're working in.

The only other thing I can think of is to have Workbook_Open() create the buttons, so that they are always assigned the correct macro. You would either want Workbook_BeforeClose() to remove the buttons, or make sure that Workbook_Open() checks to see if the buttons already exists, and update the assigned macros. This is my preferred choice for all my workbooks.

It's much betterto add the ToolBars within the code, do an Advanced Search on the forum for my name 7 Toolbars- you should find example files

I do have another workbook linked to the subject workbook and use Edit->Links to manage the link. However, the linkage is not to an earlier version of the subject workbook, but to another workbook that has data that is referenced. This linked workbook does not have the marcros in it.

Yeah I had my doubts that it would include menu buttons.

Your second suggestion to me sounds like a pretty cumbersome work around that is mildly beyond my skill level at this point. I think I will wait to see if I an discover something simpler like a quick setting that I am not aware of.

My gut tells me that this is the only way to solve your problem. Usually when people manually add buttons to their menus, they assign macros that are in their Personal.xls file, so they never need to update the macro assignment.
When you are ready to venture into VBA created menu buttons, send me a PM and I'll help you get started.
There is one possible way around your problem. If the old version of the file still exists and your macros keep running them instead of the macros in the current version, you could try this:
Just assign a gateway macro to your buttons, and the gateway macro would run the macro in the ActiveWorkbook.

Please Login or Register  to view this content.

Just make sure there is a myGateWay and myActualMacro in every version. That way at least it would get to the most current version of the macro.

Can you shed some light on the "Macro in" selection box at the bottom of the Assign Macro dialog box.

The "Macro in" box is just a filter to help you find the macro you're looking for. I have 5 workbooks open at the same time with well over 300 macros between them all. When I need to assign a macro, that's the only thing that saves me. Half the time I can't remember the name of the macro I want to assign, so I need that "Macro in" box to help reduce the list I have to sort through.

Is there some subtle difference in whether I select "This Workbook" or the fully qualified name?

There is absolutely no difference at all between "This Workbook" and the full name. "This Workbook" is always 2nd in the list, right below "All Open Workbooks", so it's easy to find. Just about everybody wants to assign macros that are in the same workbook they are in, so they made it easy to find.

Another subtley that I have not mentioned is that I run this workbook on other machines (other than the one I do the development on).

When you assign a macro, Excel actually assigns the fully qualified name. If you move the workbook to another machine and it can't find the file in the correct place, it looks around for the file. If the file it's looking for is in the same folder, then it uses it, even though it has a different path than what was assigned. The path that gets assigned is basically just a starting point for Excel to start looking. In the old DOS days we used to "Set Path To myFolder, yourFolder, hisFolder, herFolder, etc." In those days the folders listed were the only place that Excel would ever look for files. Now I have no idea how they decide what folders to look in.

However, it's not clear to me what to do about it (other than the second of the two suggestions you made).

It's the only solution that I know of.