Call macro from active workbook-duplicate shortcut keys
 

I usually have several workbooks open at the same time, each with a
print macro with shortcut CTRL-P. When I press CTRL-P I want the print
macro from the active workbook to run. Often it will call the
procedure from a different (inactive) workbook, resulting in an error
message. How do make CTRL-P call the macro from the active workbook?

Call macro from active workbook-duplicate shortcut keys
 

use ThisWorkbook or Activeworkbook object
-----Original Message-----
I usually have several workbooks open at the same time,
each with a
print macro with shortcut CTRL-P. When I press CTRL-P I
want the print
macro from the active workbook to run. Often it will call
the
procedure from a different (inactive) workbook, resulting
in an error
message. How do make CTRL-P call the macro from the
active workbook?
.