keep tab order after protection

[Guest]

I used the Insert, Name, Define, OK function in EXCEL to create a tab order, which works great. However, after protecting the sheet, the tab order doesn't work. Is there anway to maintain this order and protect the worksheet. Any help would be appreciated!

Thanks!

 

[Don Guillett]

IF I understand you, the cells desired must be unlocked.

--
Don Guillett
SalesAid Software
(e-mail address removed)

I used the Insert, Name, Define, OK function in EXCEL to create a tab

order, which works great. However, after protecting the sheet, the tab
order doesn't work. Is there anway to maintain this order and protect the
worksheet. Any help would be appreciated!

 

[Guest]

They're already unlocked, and I can select them with the sheet protected, it's just that the tab order doesn't work with the sheet protected.

 

[Dave Peterson]

Did you unlock those cells?

You can't tab to a locked cell on a protected sheet.

Format|cells|Protection tab is where you can unlock the cells.