I'm looking for information on the lifetime of Application Properties

Originally Posted by JosephP

the application has a lot of properties-which are you interested in?

Good to hear from you again JosephP
Actually I am interested in the lifetimes of ALL of them! (I am serious).

Originally Posted by JosephP

general rule of thumb is if it's a property you can set in the ui it will persist between sessions (except calculation mode)

um I don't think all of them do. e.g. DisplayAlerts.

Originally Posted by JosephP

another general rule is if you turned it off you should turn it back on (unless you need it off) :-)

But of course. That is #101 of programming. :-)

(Actually the reason for this thread question is not only to improve my Excel/VBA knowledge but I would like to know which properties are reset so that I don't need to add code lines to turn it back off/on again at the sub end).