Changing Workbook Property

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I posted a question earlier about how to calculate individual sheets, the
suggestion was I create a command button to do this. I created the button
and placed VBA code of:

Activesheet.Calculate

That command line works just fine, HOWEVER, the user is annoyed that the
statusbar shows 'Calculate' afterwards.

Q: Is there a workbook property that can be set to true/false that will
clear the statusbar? Similar to the 'Saved' property of a workbook.
 
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

Unwanted Calculation 5
Accuracy of Using Calculate - IMPORTANT QUESTION PLEASE 2
Excel not calculating 1
Application.Interactive=true ignored? 1
Non Working Cells after command button 1
Shared Workbook 12
Excel crashes and restarts when accessing newly created worksheet 2
Preventing "Protect Workbook" 2

Back
Top