"Risky Dave" wrote in message
...
Hi,

I am developing an XL application for use on my business system and have
hit
a problem that I don't understand (I'm not a programmer, the little I know
is
all self-taught).

When XL runs, a VBA Project called Personal.xlsb (this is Office '07 under
Vista Enterprise) kicks in. This code has been written at some point in
the
past by the business and is meant to do some automated docuement
management
(ie. ensures a new document is registered, contrls where and how saves are
done etc).

The person responsible for producing this code was a contractor who is no
longer with us and no-one else seems to understand what it does. I realise
that this is a problem for my business and I can get this resolved, so
please, no comments on the rubbish way we have done this :-)

My issue is that my application has some code that controls what the file
is
called when it closes and where it is put on the corporate networks. It
does
this automatically when the 'X' is selected or when an Exit button is
clicked. I need this functionality to provide quality control around how
my
users name the file and some other housekeeping. Inevitably, my code
conflicts with the code in Personal.xlsb.

The programmer's comment in Sub Workbook_Open() of Personal.xlsb within
the
'This Workbook' Object states that ' This function is called whenever the
personal.xls file is opened which should be every time Excel is opened.It
simply initialises the EventClass so that further events can be caught'

So:
1) What is calling the personal.xlsb as well as my own code?


It is run automaticaly when persoanl.xlsb is opened, which is done when
Excel starts.


2) How do I disable/unload it?


Why would you want to, it needs to setup these events at the start.


My apologies for the length of this posting. Hppy to provide further
details
as needed.

I do have the express permission of my business owners to be doing this!

TIA

Dave