I have a project that requires two open linked workbooks. One workbook has a number of macros assigned to CTRL- shortcuts.
How can I make each macro only work on one workbook? If I have the second workbook selected and implement a macro shortcut that is intended for the first workbook, Excel tries to apply the macro to the second workbook.
Is there a way to insure that a macro only works on the intended workbook?
Hi, Hambone70,
make use of ThisWorkbook for any sheets and ranges to limit the use to the workbook with code - if nothing has been set the macrtos would run on the ActiveWorkbook.
Ciao,
Holger
Use Code-Tags for showing your code: [code] Your Code here [/code]
Please mark your question Solved if there has been offered a solution that works fine for you
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks