View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tim Williams Tim Williams is offline
external usenet poster
 
Posts: 1,588
Default 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.