Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
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!



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Setting Tab order Rita Excel Discussion (Misc queries) 8 April 7th 09 09:13 PM
Setting the Tab Order [email protected] Excel Discussion (Misc queries) 3 October 22nd 08 10:59 PM
Setting custom Tab order Rusty Setting up and Configuration of Excel 2 May 17th 07 06:43 PM
setting order in excel M Kirwin Excel Discussion (Misc queries) 2 October 31st 06 08:58 AM
setting tab order by code dlrauh Excel Programming 1 October 25th 03 08:38 PM


All times are GMT +1. The time now is 03:17 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"