How to keep view still when running macos?
I may have jumped the gun here a bit. If I do as suggested:
Application.screenupdating = False
your macro
Application.screenupdating = True
....then unless my current view is at the topmost/left most part of the
worksheet, executing the macro WILL change my current view to be end
up being at the topmost/leftmost part of the worksheet when the macro
completes. What shoulld do to prevent this so that the current view
remains still/constant regardless of where I am on the worksheet when
I execute the macro?
Ace70
|