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.

Is it possible that the two people who experienced both workbooks closing
aren't exactly computer-savvy? I've found that people who don't really "get"
programs have a tendency to hit the "big" x in the upper right-hand corner
(like Excel and Word) when closing things, which totally closes the program
instead of the "little" x that just closes the workbook. Perhaps they
misunderstood that it closes automatically and tried to close it by hitting
the x, thus making both workbooks close. Maybe? That's just my idea, since
you're pretty sure it's not the coding (and other people haven't had any
problems).

" wrote:

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.

Thanks, but this isn't happening. They're in a different office but a
colleaugue of mine has run the program with them and seen the problem,
and they don't close any workbook in the "traditional" sense. My
hunch is that they have some indicator ticked or have set-up their
excel in a different way, but we're out of ideas as to what that may
be.