G
GregJG
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
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