View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Ron de Bruin Ron de Bruin is offline
external usenet poster
 
Posts: 11,123
Default Personal.xlsb in Excel 2007 stopped being open at start

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: HelpAbout MS ExcelDisabled items
Excel 2007 : Office buttonExcel Options..Add-ins
In the "Manage:" dropdown (bottom of the dialog)
Choose "Disabled Items
Go



--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Alojz" wrote in message ...
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?