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?
|