Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2
Default tab to next unlocked cell

Hi... hope you can help.
I have a spreadsheet with locked and unlocked cells. I would like to TAB to
the next unlocked cell available. Is there an easy way to set this up?
Thank you.
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 181
Default tab to next unlocked cell

Excel actually does this for you. Once you have established you unlocked
cells and protected the w/sheet you get the result you are looking for. If
it's not doing it you have probably not protected the w/s.
--
Russell Dawson
Excel Student

Please hit "Yes" if this post was helpful.


"ajimmitt" wrote:

Hi... hope you can help.
I have a spreadsheet with locked and unlocked cells. I would like to TAB to
the next unlocked cell available. Is there an easy way to set this up?
Thank you.

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
Moving from one unlocked cell to another Rich Excel Discussion (Misc queries) 3 March 23rd 09 02:39 PM
cannot tab to next unlocked cell iansmigger Excel Discussion (Misc queries) 0 March 13th 09 11:21 AM
open worksheet on first unlocked cell Ruth Excel Discussion (Misc queries) 5 November 12th 08 05:15 PM
Moving from unlocked cells to unlocked cells in an excel form Stacey Lee Excel Worksheet Functions 1 April 24th 06 08:44 PM
Need to add cell comments in unlocked cell on protected worksheet dan400man Excel Discussion (Misc queries) 3 December 16th 05 08:02 PM


All times are GMT +1. The time now is 12:14 PM.

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

About Us

"It's about Microsoft Excel"