Personal.xls not hidden in Excel 2007?

  • Thread starter Thread starter sam
  • Start date Start date
S

sam

Hi,

When I open a spreadsheet in Excel 2007 my Personal.xls file opens too,
in a separate window. (I get a separate "tab" in my task bar.)

If I remember correctly from Excel 2003 the Personal.xls was actually
hidden and didn't open, but the macros in it were made available to
open worksheets. In any case, that is the behavior I would like.

Is there a setting somewhere that makes the Personal.xls stay hidden?
I've tried putting it in program files/.../xlstart and in application
data/.../xlstart. I've also tried making it a .xlsb file.

Thanks,

Sam
 
I haven't tried 2007 but have you tried "hiding"

Sub TogglePersonal()
Windows("PERSONAL.XLS").Visible = Not Windows("PERSONAL.XLS").Visible
End Sub
 
I have a Personal.XLSB file - I can see it in the VBA Project window
But it does not show in Excel window - nor can I find how to make it
visible.
best wishes
 
Bernard: View tab, Window chunk, Unhide.
-- Bob
Bernard Liengme said:
I have a Personal.XLSB file - I can see it in the VBA Project window
But it does not show in Excel window - nor can I find how to make it
visible.
best wishes
Click to expand...
 
sam said:
Hi,

When I open a spreadsheet in Excel 2007 my Personal.xls file opens too,
in a separate window. (I get a separate "tab" in my task bar.)

If I remember correctly from Excel 2003 the Personal.xls was actually
hidden and didn't open, but the macros in it were made available to
open worksheets. In any case, that is the behavior I would like.

Is there a setting somewhere that makes the Personal.xls stay hidden?
I've tried putting it in program files/.../xlstart and in application
data/.../xlstart. I've also tried making it a .xlsb file.

Thanks,

Sam
Click to expand...

Hi Sam

I haven't tested it in Excel 2007, but normally you hide
it by having it on screen and then choosing Window > Hide
It should now be hidden the next time you open a workbook.
 
Thanks all. Not sure why I missed that.

In Excel 2007, choose Hide/Unhide from the Windows group in the View
ribbon tab.

Sam
 
You're welcome, Sam.

Leo Heuser


sam said:
Thanks all. Not sure why I missed that.

In Excel 2007, choose Hide/Unhide from the Windows group in the View
ribbon tab.

Sam
Click to expand...
 

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

personal.xls in 2007 4
personal.xls in Excel 2003 2
Personal.xls 4
Error After Copying Excel 2003 Macros and Toolbars from Windows Vistato Windows 7 1
Macros in Personal.xls... 3
Problem with Personal.XLS and macros added to my toolbar 3
personal.xls 3
Personal.xls doesn't open when starting with existing workbook 1

Back
Top