View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Stuart Farr Stuart Farr is offline
external usenet poster
 
Posts: 1
Default Macro to freeze screen

Can someone tell me how to write a macro that will freeze the frame
until finished. I have a file with 25 sheets which, when the file
opens, all the sheets are taken through a formatting routine. This is
fine, but you get a bit dizzy watching it. So I want to freeze the
display and show a box filling as the macro progresses. Can anyone
help?



------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from http://www.ExcelForum.com/