PERSONAL.XLS ??

[Guest]

Hi;

Somehow Personal.Xls started adding a workbook and a worksheet when I open
Excel. I want to keep the personal.xls modules but I want to stop the
workbook & sheet from opening up. How do I do that?

I have tried for a couple of hours now.

Regards Bill

 

[Die_Another_Day]

Make Personal.xls the "ActiveWorkbook" then go the the menu "Window"
and choose "Hide"

Charles

 

[Don Guillett]

I have this in my personal.xls and have it assigned to a button in my
menu.xls workbook.

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

 

[Dave Peterson]

And then close excel.

You'll be prompted to find out if you want to save personal.xls (since you made
a change making it hidden).

Answer yes.

And then restart excel.

 

[Die_Another_Day]

Aw come on, I thought he'd enjoy a recurring problem <gr> Anyhow
thanks for the reminder...

Charles