View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
John[_64_] John[_64_] is offline
external usenet poster
 
Posts: 5
Default Call macro - duplicate shortcut keys

I'm still having problems with this. 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. Someone said to try thisworkbook but I couldn't get it to work
properly. How do make CTRL-P call the macro from the active workbook.