Programmatically Disabling Excel Toolbars for one session only?
- From: "BW" <BW@xxxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Thu, 1 Sep 2005 15:08:01 -0700
Hello,
How can i programmatically disable (not display) the excel toolbars for a
single instance of excel such that the original toolbars configuration is
reappears on subsequent invocations of excel.
ie.
For Each bar In Application.CommandBars
If bar.Visible Then bar.Visible=False
Next
Problem is when i do the above, all subsequent invocations of excel will
have no toolbars displayed. Only way i can think of reverting back to
original toolbars configuration is to save which toolbars are visible, and
then set them back to true when the workbook closes but this seems very
clumsy.
is there a more efficient approach?
.
- Follow-Ups:
- Re: Programmatically Disabling Excel Toolbars for one session only?
- From: Bob Phillips
- Re: Programmatically Disabling Excel Toolbars for one session only?
- Prev by Date: RE: Need a formula that will calculate a cell of text.
- Next by Date: Re: Trouble with RANDBETWEEN
- Previous by thread: How do I use quotes in an IF statement?
- Next by thread: Re: Programmatically Disabling Excel Toolbars for one session only?
- Index(es):