Today’s post was prompted by Mr. William Benson on the Excel-L developer list who noticed that the EnableCalculation property of a worksheet was resetting to True when the workbook was reopened. I mentioned that it was one of the properties that do not persist when the workbook is closed, which naturally begged the question: which ones do persist?
After some brief experimentation, it would appear that these ones do persist:
whereas all others are reset.
Here’s a simple table of the properties, their default values and persistence:
|9||EnableSelection||0 – xlNoRestrictions||Yes|
|13||Visible||-1 – xlSheetVisible||Yes|