How to Hide PERSONAL.XLS

  • Thread starter Andrew Mackenzie
  • Start date
A

Andrew Mackenzie

Hi Folks,

I have been mucking about moving macros around and now when I open Excel the
workbook PERSONAL.XLS automatically opens. I think this is as it should be
but the workbook should be hidden. Am I right and if so how do I hide it?

Thanks and Regards,

Andrew
 
R

Ron de Bruin

Hi Andrew

What to do if your PERSONAL.XLS(B) is visible

When you open Excel and you see PERSONAL.XLS(B) in the title bar you can use this to hide it.

Excel 97-2003: Window>Hide
Excel 2007 : On the View tab in the window group choose Hide

Then close Excel and say Yes to save the changes to your PERSONAL file.
 
R

Robert Perkins

Joined
Jul 14, 2015
Messages
1
Reaction score
0
I tried the hide, but as soon as I tried to save it popped back up. When I open Excel it opens the Personal.xls. If I open another file first, it opens that file with Personal hidden, but when I close the first file, Personal pops up, without the menu and headers. I have to close using Alt-F4.

Confused and frustrated.

By-the-way, the file is Personal.XLSB, and hers is the file path:

C:\Users\my.name\AppData\Roaming\Microsoft\Windows\Recent\PERSONAL.XLSB.lnk
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Macros Available without hiding 'personal.xls'? 3
personal.xls 2
Personal.xls only opening with new workbook, not with existing 1
Personal.xls will not open when I open excel 2
Where is Windows - Unhide - Personal.xls 7
Problem with Personal.xls 4
Auto adding a macro when Excel 2003 opens 3
how to prevent macros in Personal.xls appearing in other workbook 3

Top