Thread: macro in nonactive workbook
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Monika Weber Monika Weber is offline
external usenet poster
  
Posts: 6
Default macro in nonactive workbook
Hi Paul,

maybe it is because you refer to the "ActiveWorkbook".
Try to work with their names "Workbooks("Name.xls")" ...

--
Greetings,
Monika Weber [Microsoft MVP für Excel]
http://www.jumper.ch (Office Help Desk)


Reply With QuoteReply With Quote