Hide calculations during computation

  • Thread starter Thread starter Landyman
  • Start date Start date
L

Landyman

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
 
I believe it is

application.screenupdating = false

this will keep the screen on the display at the start of the macro - o
wherever that code is put
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VBA to run all variable combinations in a calculation model and store result 6
Accuracy of Using Calculate - IMPORTANT QUESTION PLEASE 2
Force Calculation 5
Macro 2
Hide rows and prevent unhiding 2
Hide worksheet when moving back to another sheet 2
Hide a Workbook 4
Handling a worksheet calculate event in XLA code 4

Back
Top