settings and resettings
Asif,
This is probably happening due to the VBA in your excel
app changing the properties you have listed.
You need to ammend the code in your app so that it stores
your original excel settings before changing them and then
resets them back to the original settings when it closes.
For example, the Formula Bar one would look something like
this:
Global bFormulaBar As Boolean
Sub Auto_Open()
'store the original formula bar setting
bFormulaBar = Application.DisplayFormulaBar
'hide the formula bar
Application.DisplayFormulaBar = False
End Sub
Sub Auto_Close()
'reset the original setting before closing the application
Application.DisplayFormulaBar = bFormulaBar
End Sub
-----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.
|