View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Jim Rech Jim Rech is offline
external usenet poster
 
Posts: 2,718
Default Call macro - duplicate shortcut keys

The first workbook opened with a shortcut key assigned to a macro (via
Tools, Macro, Macros) gets to keep it. If the macros are all the same you
might change them so that they always operates on the active workbook, as
opposed to a named workbook or ThisWorkbook.

Sub MyPrint()
ActiveSheet.Printout
End Sub

--
Jim Rech
Excel MVP