View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Donald Lloyd Donald Lloyd is offline
external usenet poster
 
Posts: 30
Default Working with Two WorkBooks

HI,

I'm a bit mixed up with running macros from other Workbooks.

There are two workbooks open, say Book1 and Book2.
At the end of a session, with Book2 being the active workbook, I want to run
a macro (called, say ShutDown ) in Book1 which will then close Book2. I'm Ok
after that.

If it helps - Book1 is Workbooks(1) and Book2 is Workbooks(2)

Any pointers please ?

regards,
Don
--