Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to preserve state of View-Toolbars?
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to preserve state of View-Toolbars?
looking at the enabled property
I think you want the Visible property. -- Jim Rech Excel MVP "Dave" wrote in message ... | 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 | |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
replace state names with state code abbreviations | Excel Worksheet Functions | |||
How can I show state-by-state data (as silos) on a map of NA | Charts and Charting in Excel | |||
Converting State Names to State Abbreviations | Excel Discussion (Misc queries) | |||
column is hidden in normal view but not print view | Excel Worksheet Functions | |||
Detect if a command bar is enabled in View-Toolbars | Excel Programming |