Tab order in protected sheets

  • Thread starter Thread starter Tracey
  • Start date Start date
T

Tracey

Hello,
I am creating a worksheet template and I hae certain ranges of cells
unprotected. I would like to adjust the tab order in some instances,
i.e. i want it to go across, but it wants to go upward to the next
unprotected cell. Does anyone know how to change this? Or perhaps is
there a automatic macro I can write to run upon exiting a certain
cell?
Thanks,
Tracey
 
Go to the Tools menu, Options/Edit. There is an option for direction to move
after Enter.

HTH, Greg
 
Thank you, I actually saw that one, but I need it to change direction
after tab, not enter. any suggestions anyone has would be greatly
appreciated
 
Gord Dibben has posted this workaround that might be something you can use:
http://google.com/[email protected]

He suggests selecting the range (in a specific order), giving it a nice range
name and then selecting that range when you want to follow a specific tab order.
 
Back
Top