Thread: Macro that opens a separate workbook to a specified worksheet whenthe active workbook is right mouse clicked
View Single Post
  #9   Report Post  
Posted to microsoft.public.excel.programming
GS[_2_] GS[_2_] is offline
external usenet poster
  
Posts: 3,514
Default Macro that opens a separate workbook to a specified worksheet when the active workbook is right mouse clicked
It happens that GS formulated :
Application.RunAutoMacros xlAutoOpen

Sorry.., my bad! Change the above line to:

wkbSource.RunAutoMacros xlAutoOpen

--
Garry

Free usenet access at http://www.eternal-september.org
ClassicVB Users Regroup! comp.lang.basic.visual.misc


Reply With QuoteReply With Quote