View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Nikos Yannacopoulos[_4_] Nikos Yannacopoulos[_4_] is offline
external usenet poster
 
Posts: 5
Default settings and resettings

One possible reason is that the application changes your
toolbars, and Excel saves the changes in Excel.xlb without
asking (it does that!). Look in the application code if
you can, to verify. You should find code lines containing
the word "CommandBars" if that's the case.

One way to overcome this is to use a piece of code to
store your preferred settings in a file, and another one
to reset them upon request; see my reply to "Morten" 's
posting of Nov. 6, 2:34AM, titled "VVA - Excel setup" in
Excel - Miscellaneous newsgroup.

Nikos Y. (nyannaco at in dot gr)
-----Original Message-----
I use an excel-based app, which is good in every respect

except that it changes the settings of excel. After using
the program when I start excel in its normal mode, I have
to reset my formula bar, other tool bars, tab sheet etc.
My questions a
1. Why is it happening?
2. What can be done about this?

Thanks in advance.