Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #5  
Old 03-26-2012, 10:40 AM
Catalin.B Catalin.B is offline Excel - move with tab through named range Windows Vista Excel - move with tab through named range Office 2010 32bit
Expert
 
Join Date: May 2011
Location: Iaşi, Romānia
Posts: 386
Catalin.B is on a distinguished road
Default

You can do it by changing options in excel: first, go to office button, Options, Advanced--> Editing options, then , at the first option: After pressing enter , move selection to: and choose Direction: right from list (default is down)
Select the needed ranges, (A1-A7, then B1-B7, then A10-A17, then B10-B17, and so on), go to Home tab, Format-Format cells-Protection and make sure that Locked is unchecked. On the review tab, click on protect sheet, then ok (you can set a password if you want). Now, only those unlocked cells can be edited, and the selection will move to right when pressing enter.
The inconvenient in your case, is that you have to return to previous row after completing the first part of current row.
Reply With Quote
 

Tags
named range, vba



Similar Threads
Thread Thread Starter Forum Replies Last Post
How to use named ranges in excel vba? bosve73 Excel Programming 4 01-25-2012 09:26 AM
Excel - move with tab through named range load list box from range in excel Joe Patrick Word VBA 8 06-07-2011 09:31 AM
Excel - move with tab through named range Named range drop-down jgelpi16 Excel 1 04-08-2011 03:08 PM
Can't import home adresses in outlook 2010 from excel named ranges eekie Outlook 0 05-14-2010 02:04 PM
Through VBA, export range from Excel to Word duugg Word VBA 0 08-24-2009 07:50 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 03:18 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft