View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Ace70 Ace70 is offline
external usenet poster
 
Posts: 12
Default 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