Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Closed Thread
 
Thread Tools Display Modes
  #1  
Old 06-23-2016, 07:15 AM
WRowan WRowan is offline Personal Macro Workbook Does Not Load Windows XP Personal Macro Workbook Does Not Load Office 2010 32bit
Novice
Personal Macro Workbook Does Not Load
 
Join Date: Jun 2012
Posts: 4
WRowan is on a distinguished road
Default Personal Macro Workbook Does Not Load

I posted this in the Excel Programming forum yesterday but there have been no responses, so re-posting here.

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>XLSTAR T >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!?
  #2  
Old 06-23-2016, 08:26 AM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline Personal Macro Workbook Does Not Load Windows 7 64bit Personal Macro Workbook Does Not Load Office 2010 64bit
Expert
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,603
Pecoflyer is a splendid one to beholdPecoflyer is a splendid one to beholdPecoflyer is a splendid one to beholdPecoflyer is a splendid one to beholdPecoflyer is a splendid one to beholdPecoflyer is a splendid one to beholdPecoflyer is a splendid one to beholdPecoflyer is a splendid one to behold
Default

Hi
there is no need to re-post a VBA question and especially not in a non VBA forum.

Your query was only posted about 24hrs ago and had 35 views. Have a little patience. This a a free forum and sometimes one needs to be patient to get an answer.
Of course, if you deem it necessary, you can always bump a post ( usually after about 24 hrs) so it will get at the top of the list again.

To keep the forum as tidy as possible, I will close this thread

Link to existing thread https://www.msofficeforums.com/excel...-not-load.html
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post
Closed Thread

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Personal wkbook does not load WRowan Excel Programming 0 06-22-2016 06:06 AM
Personal Macro Workbook Does Not Load Macro to Dismiss Links to Corrupt Workbook Phil H Excel 1 04-20-2016 10:34 PM
How do I assign a macro to a button when the macro is in my personal workbook? foolios Excel Programming 2 07-27-2011 02:41 PM
Personal Macro Workbook Does Not Load macro to transfer data from one workbook to another workbook virsojour Excel Programming 5 02-01-2011 08:58 PM
PowerPoint Add-in fails to load in start up but loads successfully if load manually f shahbazlibra PowerPoint 0 11-30-2010 08:36 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 08:37 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2022, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2022 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft