".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
|