Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #3  
Old 12-23-2024, 09:09 AM
Bill Martz Bill Martz is offline Assigned shortcut works in open workbook but also opens closed workbook Windows 7 64bit Assigned shortcut works in open workbook but also opens closed workbook Office 2013
Novice
Assigned shortcut works in open workbook but also opens closed workbook
 
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
 



Similar Threads
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
Assigned shortcut works in open workbook but also opens closed workbook need vba code export data to closed workbook sheets manilara Excel Programming 1 02-12-2016 08:20 PM
Assigned shortcut works in open workbook but also opens closed workbook Run Code when Workbook opens gbaker Excel Programming 2 07-10-2012 10:41 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 10:26 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft