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

  • Thread starter Thread starter STEVE BELL
  • Start date Start date
S

STEVE BELL

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!
 
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Protected Sheet Problem in Excel 2000 2
EnableSelection = xlUnlockedCells 5
Protect/Unprotect w/ VBA not working as supposed... 3
EnableSelection Protecting sheet question 3
Protect sheets 6
bug in protect-unprotect macro 7
Programmatically Adding Code to a Workbook 7
Excel Excel VBA Protect setting 5

Back
Top