View Single Post
  #8   Report Post  
Posted to microsoft.public.excel.programming
Michael Lanier Michael Lanier is offline
external usenet poster
 
Posts: 74
Default Macro that opens a separate workbook to a specified worksheetwhen the active workbook is right mouse clicked

Garry

Thanks for all your effort. I tried the macro in my existing file as
well as a new file and in both it does to things. It debugs in the
following line in both:

Application.RunAutoMacros xlAutoOpen

It does however open the file. I fear I'm going to have to punt on
this one and try something else, but again, thanks for your input.

Michael