Joel,

Thanks.

How do I go about changing the name? Through the VBA environment I can see
the code associated with VBAProject (PERSONAL.XLSB) but cannot figure out how
to change the bracketed part - the Project Properties only let me change the
'VBAProject' text.

Dave

"Joel" wrote:

You can delete it or rename the personal.xlsb file. Excel automatically
looks for this file whenever an excel file is opened. I would rename it
personal.xlsb.old just incase there is something that you really need in the
file you can recover it later.

"Risky Dave" wrote:

Bob, to make myself clear (and in reverse order):

2) This functionality is not used by the business, so all it is doing is
getting in my way :-(

1) Yes, but how? I think I mean, has the Excel application code been
modified to call this functionality or is it something I can switch off via
my own code within a VBA module or some such?

Hope this clarifies,

Dave


< snipped by Dave



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