Disable Scrolling while Macro is Running

[AK_Excel_13]

How do I disable scrolling while my macro is running? I want my screen/window to be locked when the macro starts and unlocked when the macro ends.

However, I do not want to disable ScreenUpdating.

Application.ScreenUpdating = False
Set x = ActiveCell
***macro***
x.Select
Application.ScreenUpdating = True

Thanks!

 

[JoeMo]

Is the macro recorded? Does the macro cause the scrolling?

 

[AK_Excel_13]

The macro causes the scrolling, but I want the scrolling to be disabled while the macro runs.

 

[JoeMo]

The macro causes the scrolling, but I want the scrolling to be disabled while the macro runs.

Can you post the code?

 

[AK_Excel_13]

I would rather not post the code because it has sensitive information on it. Sorry.

The macro selects other cells which causes the scrolling. I would like the macro to stop all scrolling or lock the screen while the screen is updating.
If I get rid of all the selecting that the macro does then maybe I can stop the scrolling.

 

[Michael M]

That makes it difficult, if we can't see the code !!
As a suggestion any lines that end with .Select, followed by a line that has .Selection at the beginning can be modified and joined like this

Range("A1").Select
Selection.copy


CAN BECOME

Range("A1").copy