Disable Personal.XLSB

R

Risky Dave

Hi,

I am running an XL application on my Corporate network which does a whole
stack of stuff, most of whole I have been able to get working (mostly thanks
to you guys!).

There is a legacy bit of code (ie. we don't use it anymore) which loads the
Personal.XLSB (this is Office '07 on Vista Enterprise) that is mucking up
some stuff I need to do.

Can anyone suggest some sort of Workbook_Activate() code that will disable
or unload the stuff being called by Private.XLSB for the duration of my
workbook session?

TIA

Dave
 
O

Orion Cochrane

Try entering an alternative startup path (or Trusted Location). Not sure how
to do it in Excel 2007, but it has to do with clicking the Office Logo button
and going to Excel Options. If that doesn't work, move your PERSONAL.xlsb
somewhere else. I am not sure what the startup path is for the XLSTART folder
in Vista.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

What is calling this? 5
Book2 on open; click on X's twice to close Excel 2007? 0
Treansposition - use arrays? 3
XL 2007 - grinding down to a halt after many rows - no objects,shapes or pagesetups 4
Visible data entries 1
Variation on the protection themes 1
Data Validation Error 0
How to handle user input error 2

Top