View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Don Wiss Don Wiss is offline
external usenet poster
 
Posts: 300
Default Macro shortcuts are running macros in different open workbook

I use the same macro shortcuts in different workbooks. Sometimes the
shortcuts run the same macro and act on the active worksheet. In those
cases if the shortcut runs the macro from a non-active workbook it will
still work. But one of the shortcuts has a different meaning in another
workbook, and if the shortcut decides to run the macro in that workbook
then it doesn't work.

When I use a shortcut how do I get it to run the macro in the active
workbook?

Don. www.donwiss.com (e-mail link at home page bottom).