View Single Post
 
Old 06-22-2016, 06:06 AM
WRowan WRowan is offline Windows XP Office 2010 32bit
Novice
 
Join Date: Jun 2012
Posts: 4
WRowan is on a distinguished road
Default Personal wkbook does not load

Windows 7, MO 2013

My Personal.xlsb wkbook (PWB) does not load when I start Excel or open another Excel file, making the macros in the PWB unavailable. Here is what I have tried:

1. View>Unhide is grayed out

2. File>Options>Add-Ins>Disabled Items>Go shows nothing disabled

3. Other Excel Options:
  • Trusted Locations: "Disable all Trusted Locations" is NOT checked.
  • Trusted Documents: "Disable Trusted Documents" is NOT checked.
  • Add-ins: No checkboxes are checked.
  • Macro Settings: “Disable all macros with notification” is checked. "Trust access to the VBA project object model" is checked.

4. File>Options>Trust Center>Trusted Center Settings>Trusted Locations>Add new location. I tried adding the location of the Personal.xlsb file, but I get a message the location “has already been added.”

5. Lastly, I tried the following:
C>Users>me>AppData>Roaming>Microsoft>Excel>XLSTART >deleted the Personal workbook and created a new file with the same name, recorded a macro and closed. I then opened a new workbook but the macro in Personal is not available, and View>Unhide is grayed out. If I then open the Personal workbook using File>Open, the macro in the Personal wkbook becomes available in any other open workbook. But the Personal workbook will still not load on its own “behind the scenes” when initially opening another file or the program.

Completely out of ideas. Help!?

Last edited by WRowan; 06-22-2016 at 08:48 AM. Reason: spelling correction
Reply With Quote