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
personal.xlb not seeming to load
-
- 4StarLounger
- Posts: 545
- Joined: 30 Mar 2010, 18:49
- Location: United States
-
- NewLounger
- Posts: 4
- Joined: 20 Nov 2010, 16:41
Re: personal.xlb not seeming to load
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.
-
- Administrator
- Posts: 78631
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
Re: personal.xlb not seeming to load
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.
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
Hans
-
- 4StarLounger
- Posts: 545
- Joined: 30 Mar 2010, 18:49
- Location: United States
Re: personal.xlb not seeming to load
Hey all,
That did the trick. Did not think to look there.
Thanks,
Brad
That did the trick. Did not think to look there.
Thanks,
Brad