Multiple problems with Personal Workbook

Neori

New Member
Joined
Oct 3, 2014
Messages
5
Hello!

I have always saved macro recordings inPersonal Workbook and had no trouble of using the code in new excel documents.

After that I have lost Personal Macro. Looking through the forum I could locate in XLStart file. I have checked Trust Center, Add-ins and advanced options and recovered it.

There are 2 problems now:

1) Whenever I open a new document, after going to Developer-Macro I can's see Personal Workbook in the list. However, if I go to VB editor the project is in there with all the modules. How do I adjust Excel to display Personal Workbook in the list?

2) Even if I don't save a workbook a new projected is added each time I close an Excel document. For example: I open a new workbook called workbook1, close it and then when I open a new Excel workbook2 I see in VB editor project from workbook1, although it is closed and I didn't save it.

Thank you for any reply in advance.
 

Some videos you may like

Excel Facts

Last used cell?
Press Ctrl+End to move to what Excel thinks is the last used cell.

mole999

Moderator
Joined
Oct 23, 2004
Messages
10,513
Office Version
  1. 2019
  2. 2016
  3. 2013
Platform
  1. Windows
on 2, i occassionaly see residuals in VBA, if you close excel and reopens is it still there
 

RoryA

MrExcel MVP, Moderator
Joined
May 2, 2008
Messages
35,486
Office Version
  1. 365
  2. 2019
  3. 2016
  4. 2010
Platform
  1. Windows
  2. MacOS
Re point 1, I'd start by going into the Add-ins section in options, and checking the Disabled items section to see if Personal.xlsb is listed there.
 

Neori

New Member
Joined
Oct 3, 2014
Messages
5
Thank you for your reply.

I have checked it and personal.xlsb is not disabled. This is really strange...
 

Neori

New Member
Joined
Oct 3, 2014
Messages
5
I checked Trust Center and XLStart file is in there as well.

Interestingly, even if I delete empty workbooks, the next time I open a new document there is a project for the workbook I have created last time.

Now, there is also an error showing that personal.xlsb must run for me to be able to save new macro.
 

Watch MrExcel Video

Forum statistics

Threads
1,108,611
Messages
5,523,889
Members
409,542
Latest member
Shezz01

This Week's Hot Topics

Top