On Apr 22, 12:15 am, Ken Johnson wrote:
On Apr 21, 11:53 pm, "Norman Jones"
wrote:



Hi Ken.

In xl2002+ the EnableSelection property can be set manually,
as a protection option, and will persist.

---
Regards,
Norman

Hi Norman,

It is persistent between sessions on my son's computer, but not on
mine.
I thought this lack of persistence was removed after xl2000.
Also, I need to avoid VBA (I will be deleting it from the SavedAs
copy) because the final workbook will be used where I'm expecting a
lot of reluctance to opening workbooks with macros.

Ken Johnson

Hi Norman,

I just tested on my son's computer and it is as you say. I made sure
the worksheet started out manually protected with select unlocked
cells and select locked cell, ran the code, exited excel and reopened
the SaveAs copy and all cells could be selected, so it does not
persist between sessions when set programatically, which is a pity.

Thanks for helping me clear that up.

Ken Johnson

Hi Norman,

I don't think I'm perfectly clear about this though.

There is still a definite difference between my Pentium 3 and my son's
AMD64.

On his machine if the worksheet started out manually with
EnableSelection = xlUnlockedCells it remains so in the SaveAs copy
resulting from my macro.
On my machine the SaveAs copy ends up with EnableSelection =
xlNoRestrictions

Also, that weird behaviour of the UserInterfaceOnly argument only
occurred on my machine.

Ken Johnson