 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / New Users / August 2007Move to next unprotected cell
Windows XP ,Office 2003 I have designed a form in which certain cells are protected. In some rows there is more than one unprotected cell, in others, only one unprotected cell. After entering data in an unprotected cell, pressing the 'Enter' key causes the curser to move to the first unprotected cell in the next row, whereas I require the curser to move to the next unprotected cell on the same row - and only moving to the next row when all cells on that row have been completed. How do I achieve this requirement? One way would be to use a worksheet_change event where you would not need to protect. Right click sheet tab>view code>insert this>adjust mc num to suit>SAVE Private Sub Worksheet_Change(ByVal Target As Range) mc = 6 With Target If .Column > mc Then Exit Sub If .Column = mc Then .Offset(1, -mc + 1).Select If .Column < mc Then .Offset(, 1).Select End With End Sub  SignatureDon Guillett Microsoft MVP Excel SalesAid Software dguillett1@austin.rr.com > Windows XP ,Office 2003 > I have designed a form in which certain cells are protected. [quoted text clipped - 6 lines] > been completed. > How do I achieve this requirement? I am a newby and with respect, is there no easier way? > One way would be to use a worksheet_change event where you would not need > to protect. Right click sheet tab>view code>insert this>adjust mc num to [quoted text clipped - 18 lines] >> have been completed. >> How do I achieve this requirement? Try it. SignatureDon Guillett Microsoft MVP Excel SalesAid Software dguillett1@austin.rr.com >I am a newby and with respect, is there no easier way? > [quoted text clipped - 20 lines] >>> have been completed. >>> How do I achieve this requirement? Stan, Try using Tab instead of Enter. SignatureEarl Kiosterud www.smokeylake.com Note: Top-posting has been the norm here. Some folks prefer bottom-posting. But if you bottom-post to a reply that's already top-posted, the thread gets messy. When in Rome... ----------------------------------------------------------------------- > Windows XP ,Office 2003 > I have designed a form in which certain cells are protected. [quoted text clipped - 5 lines] > cells on that row have been completed. > How do I achieve this requirement? Tools>Options>Edit>Move selection anfter Enter. Check "Right" Gord Dibben MS Excel MVP >Windows XP ,Office 2003 >I have designed a form in which certain cells are protected. [quoted text clipped - 6 lines] >completed. >How do I achieve this requirement? Thanks Gord! > Tools>Options>Edit>Move selection anfter Enter. > [quoted text clipped - 14 lines] >>completed. >>How do I achieve this requirement? |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.