View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
[email protected] irfon.glyn@kpmg.co.uk is offline
external usenet poster
 
Posts: 2
Default workbook "a" disappears on closing workbook "b"

I have a workbook (call it "b") that opens up workbook "a" and makes
changes to it. At the end of the program I have a simple bit of code
that closes workbook "b" (i.e. the main one) saving any changes made,
but I want workbook "a" to stay open.

This s/s has been used by about a dozen people without any problems,
but 2 more people used it and on finishing the program workbook "b"
closed as expected then workbook "a" just disappeared. Looking in the
VB workbook "a" was still there with the "add-in" property set to
false. I changed this to true then back to false and the s/s re-
appears.

I've searched these groups but no luck, so does anyone have any
ideas? I don't think it's a coding issue because it works for some
people but not for others so I haven't supplied example code, however
I'm happy to give more details if required.