Thread: Hide calculations during computation
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Landyman[_3_] Landyman[_3_] is offline
external usenet poster
  
Posts: 1
Default Hide calculations during computation

Hi, I am very much a VBA novice, but have developed a macro, that take
a few minutes to run. Is there anyway to display a blank screen (an
possibly with a prompt saying "Processing...") to hide the workbook a
it calculates through.

The workbook has 8 sheets, that get unhidden and hidden again as th
calculations occur.

Is there a basic VBA code that can do this

Im using Excel 2000.

Thanks, Hamis

--
Landyma
-----------------------------------------------------------------------
Landyman's Profile: http://www.excelforum.com/member.php...nfo&userid=807
View this thread: http://www.excelforum.com/showthread.php?threadid=26909

Reply With QuoteReply With Quote