personal.xlb not seeming to load

bradjedis
4StarLounger
Posts: 538
Joined: 30 Mar 2010, 18:49
Location: United States

personal.xlb not seeming to load

Post by bradjedis »

greetings,

I have an issue where excel 2007 is not seeming to load the personal.xlb. I have a macro I placed into the personal.xlb It is not working. If I run the macro by itself, it works.

Any Ideas?

Thanks,
Brad

starcrwzr
NewLounger
Posts: 4
Joined: 20 Nov 2010, 16:41

Re: personal.xlb not seeming to load

Post by starcrwzr »

This happens to me occasionally, due to a loading error at start-up, the personal.xlb will be disabled as as an add-in. Go to Settings, Add-ins, then in the list box at the bottom, select "Disabled Items". If you see personal.xlb, the highlight it and click the "Enable" button. Click OK to back out. It should work correctly now.

User avatar
HansV
Administrator
Posts: 78524
Joined: 16 Jan 2010, 00:14
Status: Microsoft MVP
Location: Wageningen, The Netherlands

Re: personal.xlb not seeming to load

Post by HansV »

To be more precise: click the Office button, then Excel Options.
Then click Add-Ins and select Disabled Items from the Manage dropdown.
By the way, the personal macro workbook is Personal.xlsb in Excel 2007 and 2010.
Best wishes,
Hans

bradjedis
4StarLounger
Posts: 538
Joined: 30 Mar 2010, 18:49
Location: United States

Re: personal.xlb not seeming to load

Post by bradjedis »

Hey all,
That did the trick. Did not think to look there.


Thanks,
Brad