Thread: Cell Tab Order
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default Cell Tab Order

Range("B1,C21,B2,D14,B4,F12,A3").Select
then use the tab key.

Other than that, you would have to code each move combination in the
selectionchange event.

--
Regards,
Tom Ogilvy


"Phil Hageman" wrote in message
...
Is there a way to control tab order among cells - simialar
to Access? For example, in a protected worksheet I want
to tab through the unprotected cells in a particular
order. How would this be done?