Assigned shortcut works in open workbook but also opens closed workbook

[Bill Martz]

During 2024, I assigned a shortcut to a macro in a workbook for tracking finances. At the end of each year, I make a copy of the workbook and convert it to work for the upcoming year. I have prepared a copy of the 2024 workbook and converted it for 2025. I find now that when I use the shortcut in the 2024 workbook, it opens the 2025 workbook, even though it is closed. I don't want to change the shortcut for every workbook I create. Is there a way to have the shortcut work for only the open workbook?

[Logit]

#1 Sounds like your shortcut references the 2024 workbook and not the 2025 ?

#2 If both workbooks are in the same folder, try moving one to a different folder ?

[Bill Martz]

Moved Financial Report 2025 to a different folder and then tried to run macro with shortcut in Financial Report 2024 and this popped up:







So I moved it back to the original folder.


The shortcut was assigned to the 2024 workbook macro UpdateAccountActualTable some months ago. A week ago it was assigned to the 2025 workbook macro. When I press the shortcut key combination Alt+Ctrl+d while working in the 2024 workbook, the 2025 workbook opens and tried to run the macro, which produces a message box saying it can't be run until 2025, and then the macro runs in the 2024 workbook.


I was running the macro by clicking on a text box button that had the macro assigned to it. I wanted to make life easier, so I assigned the shortcut to the macro. It appears that shortcuts don't just apply to the workbook you are working in, but to all workbooks, open or closed, in which the shortcut is assigned to a macro.

[Bill Martz]

What popped up was a dialog box saying the 2025 file couldn't be found. My screenshot didn't get posted.

[Bill Martz]

I have realized I didn't assign the shortcut using the Macro dialog. I put it in a Workbook_Open macro using OnKey. Even after commenting that out, and trying to remove any shortcut assigned by using Macro/Options, the macro still runs.

[Bill Martz]

Since the macro only works during the year the workbook applies to, I decided to disable the shortcut in the 2025 workbook until 2025. It seems to be a weakness that a shortcut doesn't only work in the open workbook.

[Bill Martz]

When I tried to disable the shortcut, it did not work until I restarted my computer. I suspect that if I had closed all workbooks and reopened the 2024 workbook, I would have found the shortcut disabled in the 2025 workbook. Restart not needed. Just a guess right now. Not going to bother testing it.