Once a sheet has been locked is it possible to make excel tab between locked
cells?

i.e. have one range they can tab without being able to format any of the
cells?

I Find that if you Lock all the cells in the worksheet, then unlock the ones
you want to tab between it will let you tab the range when the sheet is
protected. As regards the formatting when protecting the sheet just deselect
the format cells check box and away you go!. Hope it helps.

"Richard Umney" wrote:

Once a sheet has been locked is it possible to make excel tab between locked
cells?

i.e. have one range they can tab without being able to format any of the
cells?

Sorry i dont think you understood,
I want to protect cells from having their formats edited, but allow tabbing
to them as well.

thanks,

"andrewbt" wrote:

I Find that if you Lock all the cells in the worksheet, then unlock the ones
you want to tab between it will let you tab the range when the sheet is
protected. As regards the formatting when protecting the sheet just deselect
the format cells check box and away you go!. Hope it helps.

"Richard Umney" wrote:

Once a sheet has been locked is it possible to make excel tab between locked
cells?

i.e. have one range they can tab without being able to format any of the
cells?