Locked cells tabbing?

G

Guest

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?
 
G

Guest

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

Guest

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

thanks,
 

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

Top