View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default Very simple ? on setting up tab order

Just note that that setting is not retained if you close the workbook and
reopen it. You will need to use the workbook open event to set the
enableselection property.

--
Regards,
Tom Ogilvy

"Justine Wolfley" wrote in message
...
Oh my gosh! I just figured it out. Upon protecting the workbook if I
select Allow User to: Select unlocked cells only then when they hit
enter or tab they go down the list of unlocked cells and skip the locked
cells in order. Wow! That is really cool. Thanks again!

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!