Screen still changes. Why ? (Application.Screenupdating = False not working
 

I have a Userfrom displayed upon the press of a button,

Sub Button10_Click()
Application.ScreenUpdating = False
UserForm4.Show
Application.ScreenUpdating = True
End Sub

BUT the page still changes why?
I also have the Application.Screenupdating = false included in the
Userfor4.Activate event too.

Corey....

Screen still changes. Why ? (Application.Screenupdating = False not working
 

Corey.
Application=Excel
Userform=VBA

Not sure what you are hoping to achieve, but you can Load a userform without
..Showing it

NickHK

"Coza" wrote in message
...
I have a Userfrom displayed upon the press of a button,

Sub Button10_Click()
Application.ScreenUpdating = False
UserForm4.Show
Application.ScreenUpdating = True
End Sub

BUT the page still changes why?
I also have the Application.Screenupdating = false included in the
Userfor4.Activate event too.

Corey....