Saved As xlsm still runs macros from old macro workbook.

[JeffGrant]

Hi All,

I have created a copy of my current macro workbook which I now use as the main workbook. For some reason when I run a macro from the new workbook, it opens the old workbook and runs macros from there.

In my VBA Project the name is correct for the current workbook.

None of my macros specifically reference a workbook name, so I am little lost on this one.

Any ideas would be great.

Thanks

 

[JeffGrant]

Ahhh... sometimes writing things into a forum helps me solve my own problem. I have worked out that the custom ribbon bar points to the old workbook and therefore automatically runs the macros from there.

Is there anyway to update the ribbon bar without having to rebuild it?

Thanks in advance.