".Protect userinterfaceonly:=True" & ".EnableSelection = xlUnlockedCells" not tabing
 

Any help is greatly appreciated.

I am using the following snippet in code to protect locked cells and allow
the user to only select unlocked cells.

.Protect userinterfaceonly:=True
.EnableSelection = xlUnlockedCells

This previously worked great in Excel 2000. Now I have both 2000 and 2003
loaded on the same computer. The Tab or Enter key used to advance to the
next unprotected cell. Now most of the time it won't properly tab. And
when selecting a cell I get the "I" bar but no selection around the cell.
(in some rare instances it works correctly - but I have no idea of why).

Again - any and all help is appreciated!

--
steveB

Remove "AYN" from email to respond

".Protect userinterfaceonly:=True" & ".EnableSelection = xlUnlocke
 

Steve,

Excel's behavior with both of these settings seems to vary between versions.
The .Protect Userinterfaceonly setting needs to be applied when the workbook
opens because Excel doesn't retain it.<??

The .EnableSelection setting isn't retained either (I think), so it too
should be applied on opening.

Regards,
GS