Tabbed cells?

[Phil Hageman]

Is there code I can put in a worksheet code page that will
tab only certain cells, and not allow the user to select
any other cell? Unprotected cells are the targets here.

Thanks, Phil

 

[Jon Peltier]

Phil -

First, unlock the cells you want to allow access to, then protect the
worksheet. In vba, either in a procedure or in the immediate window,
use this command:

activesheet.enableselection = xlunlockedcells

Unfortunately, the workbook forgets this setting, so you have to reapply
it whenever it is reopened.

- Jon

 

[Phil Hageman]

Thanks, Jon - I'll try it out.

-----Original Message-----
Phil -

First, unlock the cells you want to allow access to, then protect the
worksheet. In vba, either in a procedure or in the immediate window,
use this command:

activesheet.enableselection = xlunlockedcells

Unfortunately, the workbook forgets this setting, so you have to reapply
it whenever it is reopened.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
http://www.geocities.com/jonpeltier/Excel/index.html
_______



.

 

[Phil Hageman]

This works fine - it tabs all the unlocked cells. Now, is
there a way to keep the user from selecting a locked cell?

 

[Jon Peltier]

Phil -

The line of code I provided should do that as well:
activesheet.enableselection = xlunlockedcells

- Jon