Personal.xls not hidden in Excel 2007?

[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

 

[Don Guillett]

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

Sub TogglePersonal()
Windows("PERSONAL.XLS").Visible = Not Windows("PERSONAL.XLS").Visible
End Sub

 

[Bernard Liengme]

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

 

[Bob Umlas]

Bernard: View tab, Window chunk, Unhide.
-- Bob

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

 

[Leo Heuser]

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

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.

 

[sam]

Thanks all. Not sure why I missed that.

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

Sam

 

[Leo Heuser]

You're welcome, Sam.

Leo Heuser

Thanks all. Not sure why I missed that.

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

Sam