C
Callie
When opening and excel spreadsheet, it opens the file in multiple window with
each one being in a different view. How do you stop this?
each one being in a different view. How do you stop this?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
J
JE McGimpsey
One way:
Put this in the ThisWorkbook code module:
Private Sub Workbook_Open()
Dim i As Long
With Me.Windows
For i = .Count To 2 Step -1
.Item(i).Close
Next i
End With
End Sub
If you're unfamiliar with macros, see
http://www.mvps.org/dmcritchie/excel/getstarted.htm
Put this in the ThisWorkbook code module:
Private Sub Workbook_Open()
Dim i As Long
With Me.Windows
For i = .Count To 2 Step -1
.Item(i).Close
Next i
End With
End Sub
If you're unfamiliar with macros, see
http://www.mvps.org/dmcritchie/excel/getstarted.htm
C
Callie
This macro did close the other open windows but can you tell me what caused
this to happen from the begininng?
this to happen from the begininng?
J
JE McGimpsey
Choosing Window/New Window from the menu.
C