Personal Macro Book and VBE showing
 

At work, when I unlock my computer after it has either "timed out" or
been locked, the VBE will be showing a module of the Personal.xlsb
even if there is no Excel workbook open. Another person at work just
told me that she has experienced the same thing. Does any one know
anything about this phenomenon?

Personal Macro Book and VBE showing
 

No workbook open, but obviously Excel is still running if you can access the
VBE.

It is normal for Personal macro workbook to be open in that case.


Gord Dibben MS Excel MVP

On Mon, 3 Jan 2011 16:55:17 -0800 (PST), Slim Slender
wrote:

At work, when I unlock my computer after it has either "timed out" or
been locked, the VBE will be showing a module of the Personal.xlsb
even if there is no Excel workbook open. Another person at work just
told me that she has experienced the same thing. Does any one know
anything about this phenomenon?

Personal Macro Book and VBE showing
 

On Jan 3, 8:28*pm, Gord Dibben wrote:
No workbook open, but obviously Excel is still running if you can access the
VBE.

It is normal for Personal macro workbook to be open in that case.

Gord Dibben * * MS Excel MVP


I get that the Personal macro book would be "open" if the Excel
application is running but why would it sometimes display a random
module in the VBE while other times it remains hidden and some other
application that I have open is displayed?

Personal Macro Book and VBE showing
 

Not sure what you are saying.

Personal.xls should remain hidden at all times if you have saved as hidden.

"Hidden" means you will not see any Personal.xls worksheets on screen when Excel
is running.

When you hit Alt + F11 to open VBE you will see Personal.xls in the Project
Explorer.

You may have opened a module for editing or just to have a look?


Gord

On Mon, 3 Jan 2011 18:21:39 -0800 (PST), Slim Slender
wrote:

On Jan 3, 8:28*pm, Gord Dibben wrote:
No workbook open, but obviously Excel is still running if you can access the
VBE.

It is normal for Personal macro workbook to be open in that case.

Gord Dibben * * MS Excel MVP


I get that the Personal macro book would be "open" if the Excel
application is running but why would it sometimes display a random
module in the VBE while other times it remains hidden and some other
application that I have open is displayed?