Screen Updating.

[Ben E]

Hi All, I'm having a little problem with screen updating,
it doesn't seem to be turning off, I have set the code to
ScreenUpdating = False, but it still shows the updating on
information on the screen as it happens.

Sub GetTheData ()

Application.ScreenUpdating = False

Sheets("Daily Sales").Select
ActiveSheet.Unprotect
Range("D560").ClearContents

Range("D5").Select

Call PickUpData

Application.ScreenUpdating = True

End Sub

PickUpData- Opens another file and copies over a set data
range.

This should all happen in the background, but the user can
see what is happening, any ideas as to why this is
happening, or a solution would be appreciated.

Ben E

 

[Jim Rech]

Unless PickupData turns the screen back on, or a Workbook_Open even macro in
the other workbook does the same, I would expect screen updating to stay
off...

--
Jim Rech
Excel MVP
|
| Hi All, I'm having a little problem with screen updating,
| it doesn't seem to be turning off, I have set the code to
| ScreenUpdating = False, but it still shows the updating on
| information on the screen as it happens.
|
| Sub GetTheData ()
|
| Application.ScreenUpdating = False
|
| Sheets("Daily Sales").Select
| ActiveSheet.Unprotect
| Range("D560").ClearContents
|
| Range("D5").Select
|
| Call PickUpData
|
| Application.ScreenUpdating = True
|
| End Sub
|
| PickUpData- Opens another file and copies over a set data
| range.
|
| This should all happen in the background, but the user can
| see what is happening, any ideas as to why this is
| happening, or a solution would be appreciated.
|
| Ben E
|