Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Manually changing a picture (shape) name property | Excel Discussion (Misc queries) | |||
changing an activex control property using a macro | Excel Discussion (Misc queries) | |||
changing property of a picture that is already pasted on excel | New Users to Excel | |||
listbox shrinks to a line when changing between sheets if I use the visible property | Excel Programming | |||
DisplayAlerts property is not changing to False | Excel Programming |