LinkBack URL
About LinkBacks
To use active workbook, I would need to copy paste the macro to the new workbook each time. I wanna have the macro in the background in another workbook so whenever I open a new workbook, I can just execute it with a shortcut.
To use active workbook, I would need to copy paste the macro to the new workbook each time. I wanna have the macro in the background in another workbook so whenever I open a new workbook, I can just execute it with a shortcut.
No, you would not. It will refer to whatever workbook is active when the code is running, no matter which workbook the code is in. ThisWorkbook by contrast, as Trevor said, always refers to the workbook with the code in it.Originally Posted by skhande2
Everyone who confuses correlation and causation ends up dead.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks