| 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 | |||
Linear Mode
