Detect if a command bar is enabled in View-Toolbars
Hi Gang,
I have an application that I
1. Check to see if a toobar exists, and if it does, delete it
2. Create the tool Bar.
I would like to check to see if the user has enabled the tool par (i.e.
persist state
and honor on re-start).
So, I can see where my aproach in 1 & 2 is a problem (how can you persist if
you
delete?).
Does anyone have any suggestions. My desire is to:
1. After Wise install (i.e. my .xla file is installed in XLSTART) have the
toolbar
installed and visible.
2. When the user enteres and selected visible (check) or non-visible (uncheck)
persist this for the next time Excel is opened.
Thanks,
Dave
|