View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
L. Howard Kittle L. Howard Kittle is offline
external usenet poster
 
Posts: 698
Default Hide screen movements when a macro is running

You are welcome, thanks for the feed back.

H'wd

"STatAGL" wrote in message
...
I generally create Macros by recording keystrokes.
One macro I have moves around the spreadsheet for about 5 minutes,
copying,
pasting etc etc
But I do not want the user of the spreadsheet to see all the
movements...even though they are so quick...effectively is there a way to
'freeze the screen' at the start of the macro...so all the movement is
hidden. It may be something I have to turn back on again at the end of
the
macro?

Thanks for any help available