hiding macros

  • Thread starter Thread starter GregJG
  • Start date Start date
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
 
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).
 
Back
Top