How to preserve state of View->Toolbars?

[Guest]

How does one preserve the checked/un-checked state of a toolbar in
View->Toolbars? For example, adding adding a toolbar in the Workbook_Open
event after checking for a specific add-in (per Ron de Bruin's solution in
question "Detect if a command bar is enabled in View"), closing the workbook
reopening, the toolbar is visible and checked again. I'd like to test if the
user had previously un-checked the visual display of the toolbar. I tried
itterating thropugh the commandBars collection and looking at the enabled
property, but this doesn't appear to be where excel saves that state.

Thanks for any help,

Dave

 

[Jim Rech]

looking at the enabled property

I think you want the Visible property.

--
Jim Rech
Excel MVP
| How does one preserve the checked/un-checked state of a toolbar in
| View->Toolbars? For example, adding adding a toolbar in the Workbook_Open
| event after checking for a specific add-in (per Ron de Bruin's solution in
| question "Detect if a command bar is enabled in View"), closing the
workbook
| reopening, the toolbar is visible and checked again. I'd like to test if
the
| user had previously un-checked the visual display of the toolbar. I tried
| itterating thropugh the commandBars collection and looking at the enabled
| property, but this doesn't appear to be where excel saves that state.
|
| Thanks for any help,
|
| Dave
|