View Single Post
 
Old 12-23-2024, 09:09 AM
Bill Martz Bill Martz is offline Windows 7 64bit Office 2013
Novice
 
Join Date: Apr 2015
Posts: 9
Bill Martz is on a distinguished road
Default

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.
Reply With Quote