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

Originally Posted by MarvinP

I believe you are asking for something that doesn't exist. It is cool that you are dreaming there is a "lifetime of application property" but I never got a reply of what exactly it is or was.

Good to hear from you again MarvinP.
I'm not certain I am using the correct terminology - maybe that is causing the confusion?

Application properties do exist. And I would be very surprised if you are not already using them.

Have you ever used Application.ScreenUpdating = False at the start of a macro? Application.ScreenUpdating is just one example of an Application property. The action of changing the value from False to True is an example of making a change to the value of an Application property.

Now up until recently, I was under the delusion that Application properties stayed at whatever value you left them at. I recently discovered that is not so. Certain Application properties have their values reset by Excel. I want to know which ones are changed by Excel and when (e.g. on sub end, on workbook close, on application close). This is what I am calling the "lifetime" - how long it takes for Excel to trigger a reset back to that application properties default value.

Originally Posted by MarvinP

You did mention a log file and I'm wondering if you are any closer to it now?

I have started a related thread and the log file I mentioned to you is uploaded there. See the link provided in post #24 in this thread. Thanks.