MWE
10-08-2010, 07:18 AM
I am using Excel2003. I have 4 VBA libraries that are used by xl applications:
the standard Personal.xls
LibA.xls
LibB.xls
LibC.xlsPersonal.xls sits in the XLSTART directory. The other 3 reside in their own directories with shortcuts to their locations in the XLSTART directory. Each library contains 50 to 100+ VBA routines, so keeping them separate makes sense (to me). 95% of my applications do not use Libs A, B or C, but it is a lot easier to always have them available when xl opens than to mess around with things.
This setup is identical on two computers, both running WinXP Pro and Office 2003. On one of the computers, LibB appears to be "changed" so that when I close Excel, I am always asked if I want to save it. I have not changed LibB and there is no reason for xl to think that I have, but I am always asked if I want to save it. This behavior does not occur on the other computer.
Any idea what might be happening here?
the standard Personal.xls
LibA.xls
LibB.xls
LibC.xlsPersonal.xls sits in the XLSTART directory. The other 3 reside in their own directories with shortcuts to their locations in the XLSTART directory. Each library contains 50 to 100+ VBA routines, so keeping them separate makes sense (to me). 95% of my applications do not use Libs A, B or C, but it is a lot easier to always have them available when xl opens than to mess around with things.
This setup is identical on two computers, both running WinXP Pro and Office 2003. On one of the computers, LibB appears to be "changed" so that when I close Excel, I am always asked if I want to save it. I have not changed LibB and there is no reason for xl to think that I have, but I am always asked if I want to save it. This behavior does not occur on the other computer.
Any idea what might be happening here?