LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2
Default Hide screen movements when a macro is running

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
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
tabbed movements alpineuser Excel Discussion (Misc queries) 2 September 8th 09 09:44 PM
Screen flash while running macros Jay Excel Discussion (Misc queries) 2 December 3rd 07 09:25 PM
how can we hide the steps of macro running azam Excel Discussion (Misc queries) 3 January 9th 07 01:09 PM
If I have my sheets protected will that prevent me running a macro to hide certain sells? Marc Excel Worksheet Functions 0 May 17th 06 11:36 PM
Hide "Excel" when running VB Old Car Excel Discussion (Misc queries) 5 April 30th 05 09:56 AM


All times are GMT +1. The time now is 10:11 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"