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?