![]() |
#3
|
|||
|
|||
![]()
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. |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
Workbook opens on one PC but not another | PencilPoint | Excel | 6 | 12-21-2023 12:38 AM |
Hyperlink function only fully works when referring workbook is open | batchmaster | Excel | 1 | 01-26-2018 12:27 PM |
Macro for automatically refreshing Data connection on Closed excel workbook. | ramzan11b | Excel | 1 | 11-24-2017 08:55 AM |
![]() |
manilara | Excel Programming | 1 | 02-12-2016 08:20 PM |
![]() |
gbaker | Excel Programming | 2 | 07-10-2012 10:41 AM |