Strange, but true.

But be a little careful if you share the workbook with people who use earlier
versions of excel.

The code works nicely in that case.

IanS wrote:

Thanks for the info. So, just to clarify, even though these properties are not persistent, something in the UserInterface can make the property persistent? I am very new to excel programming, and I just find it strange that it is persistent by using the Protection-Protect Sheet on the Tools menu, and the xlNoSelection sticks when I reopen, but when I do the same thing thru code, it doesn't stick.

--

Dave Peterson