![]() |
#1
|
|||
|
|||
![]()
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?
|
|
![]() |
||||
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 |