Personal.xlsb in Excel 2007 stopped being open at start

A

Alojz

Hi, several weeks ago my Personal.xlsb has stopped beeing opened at start
(when I run Excel). It is still located in XLStart folder. To use macros I
stored in it, I have to open the file manually. Then I got prompt for
allowing macros (which I solved, I add personal digital signature to the
file). So, prompt appears to be gone, yet my macros I can use only after I
open the file manually. Quite annoying. Tried to export modules elsewhere,
delete the folder and the file. Created folder again. Trying to create new
Personal.xlsb, which was not possible at all. So I had to copy Personal.xlsb
from my back-up to XLStart. Still the same. Seems like my Excel does not
recognize XLStart folder as real Start folder, I have to open Personal.xlsb
manually (it is in hiden mode, of course). Before I do that, I cannot see
this particular VBAProject - proof the file is not open. Any hint?
 
R

Ron de Bruin

Try

PERSONAL.XLS(B) will not open but is in the correct location

When Excel think the file is corrupt it can disable the file.
You can re-enable it here but if it is really corrupted replace it with a backup.

Excel 2002-2003: Help>About MS Excel>Disabled items
Excel 2007 : Office button>Excel Options..Add-ins
In the "Manage:" dropdown (bottom of the dialog)
Choose "Disabled Items
Go
 
A

Alojz

Ron,

my file was indeed disabled. To fix it was not so straightforward, as
enabling did not work (as you said, Excel still thinks this file is corrupted
even though I did not find anything bad in it). So, I again had to delete the
whole XLStart directory. Then I push Excel to create it again automatically
(while creating new Personal.xlsb in new XLStart. Then I have imported my
previous modules containing code to this new file. Now it works! Thank you
for valuable advice, which helped me to solve the issue!!!
 
H

Halula

I have the same issue (personal.xlsb not automatically opening) except I have
no items listed in the "Disabled Items" list.
Thanks for your help!
-Hannah
 

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

Top