When certain people choose "Save-as" on the workbook I made, and save it as a different name, when they try to run a macro right afterwards, it opens the previous workbook (the old name), and runs the macro in the "old" workbook.
I tried to reproduce the problem on my computer, and I cannot. Although, I have been to the users computers, and the problem persists.
Has anyone encountered this problem in the past?
Any suggestions as to what I could try to do to fix it?
It seems the problem is originating from the MACRO COMMAND BAR that i have setup. The command bar doesn't use the current workbook, but the old one instead.