View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Stuart[_5_] Stuart[_5_] is offline
external usenet poster
 
Posts: 413
Default EnableSelection = xlUnlockedCells

If I say:
With ws
.Protect
.EnableSelection = xlUnlockedCells
End With
and then save the workbook, then when I reopen
it, then it is protected, but the EnableSelection
statement is not operating.

Is this as intended? If so, then will I have to use the
Workbook Open event to set the Selection?

Regards.


---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.614 / Virus Database: 393 - Release Date: 05/03/2004