even though I use this code

Private Sub Workbook_Open()
Application.ScreenUpdating = False
Run ("sorta")
Application.ScreenUpdating = True
End Sub

I still see the macro run?

I thought it might be in userform_initialize

Application.ScreenUpdating = False
With Me
.Top = Application.Top
.Left = Application.Left
.Height = Application.Height
.Width = Application.Width
End With
cboRep.SetFocus
Application.ScreenUpdating = True
End Sub


but still I see the other workbook open.


any help

--
Message posted from http://www.ExcelForum.com

You probably need to set ScreenUpdating to False *after* the:

cboRep.SetFocus

line, and not in the Workbook_Open event, depending on what you are trying
to do (which is not entirely clear).

--

Vasant

"GregJG " wrote in message
...
even though I use this code

Private Sub Workbook_Open()
Application.ScreenUpdating = False
Run ("sorta")
Application.ScreenUpdating = True
End Sub

I still see the macro run?

I thought it might be in userform_initialize

Application.ScreenUpdating = False
With Me
Top = Application.Top
Left = Application.Left
Height = Application.Height
Width = Application.Width
End With
cboRep.SetFocus
Application.ScreenUpdating = True
End Sub


but still I see the other workbook open.


any help?


---
Message posted from http://www.ExcelForum.com/