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