Changing Workbook Property
 

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.

Changing Workbook Property
 

application.statusbar=false

Tim

"PosseJohn" wrote in message
...
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.