keep tab order after protection

R

Rawley

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

Don Guillett

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

--
Don Guillett
SalesAid Software
[email protected]
Rawley said:
I used the Insert, Name, Define, OK function in EXCEL to create a tab
Click to expand...
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!
 
R

Rawley

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

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