LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 157
Default AUTO TAB BETWEEN CELLS

If you unlock those three cells (Format Cells Protection tab, untick
Locked) then protect the worksheet (Tools Protection Protect Sheet),
then the tab button will cycle through those 3 cells.

A possible drawback with this is that the user will ONLY be able to enter
data in those 3 cells. On the other hand this could be an advantage :-)

--
Ian
--
"Tom T" wrote in message
...
I have a spreadsheet that I have three cells that I have limited the
number of characters/numbers that can be put in each cellt hrough
vailadation. Is there a way that when a person inputs the required
characters/numbers that the tab will go to the next cell? I have looked at
another question similiar to mine but that code does not work.



 
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
How to Sum-If when the cells to sum are Auto-filter visable cells? Dennis Excel Discussion (Misc queries) 3 February 24th 06 11:49 PM
is there a way to auto copy cells similar to auto sum? saki4two Excel Worksheet Functions 1 January 11th 06 08:21 PM
Auto Protecting cells & auto filling date ccarmock Excel Discussion (Misc queries) 7 September 30th 05 09:21 PM
How do I auto size cells? Aaron Mosby New Users to Excel 3 September 12th 05 10:38 PM
Auto populate cells based on 2 cells division. Chance224 Excel Discussion (Misc queries) 0 April 4th 05 09:35 PM


All times are GMT +1. The time now is 04:20 PM.

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"