personal.xls problem

[André]

I was working with macro's yesterday now any excel
workbook i open also opens the file personal.xls. How can
I stop this from opening?

A

 

[Bernard Liengme]

If there is a Personal.xls file in the correct folder, then Excel will open
it. However, this workbook normally open in hidden mode.
Try Window|Hide and close Excel. Does Personal.XLS show its face?

Best wishes

 

[Guest]

The hide option is not available, it is grayed out.

A.

 

[David McRitchie]

Make sure you are not in Edit mode, or waiting for a reply.

I have a page on "grayed out" options (greyed out)
http://www.mvps.org/dmcritchie/excel/grayedout.htm
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

The hide option is not available, it is grayed out.

A.

 

[Bernard Liengme]

With Personal as the active workbook, use Tools|Macro|VisualBasic Editor
In the Project window (left of screen), locate Personal.XLS and under it
click ThisWorkbook.
In the macro window (main window) enter this code

Private Sub Workbook_Open()
Windows(ThisWorkbook.Name).Visible = False
End Sub

Close VBA editor, save Personal.xls
Try opening it again.

--
Bernard Liengme
www.stfx.ca/people/bliengme
remove CAPS in e-mail address


The hide option is not available, it is grayed out.

A.