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

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

Charles

Bill Case wrote:
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

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

--
Don Guillett
SalesAid Software

"Bill Case" wrote in message
...
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

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 wrote:

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

Charles

Bill Case wrote:
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

--

Dave Peterson

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

Charles

Dave Peterson wrote:
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 wrote:

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

Charles

Bill Case wrote:
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

--

Dave Peterson