EXCEL HELP ASAP!!!
I created several forms in Excel (not using any templates) and now I am
trying to gray out cells, and use the TAB key to easily navigate from cell to cell that requires inputted data. I cannot figure out how to do this, like I have done in MS Word before. Suggestion and help much appreciated! Angela Davis |
EXCEL HELP ASAP!!!
A meaningful subject line along with losing the ASAP since all requests here
are urgent will help you. Look in the help section or the archives for PROTECTION. -- Don Guillett SalesAid Software "AngelaD" wrote in message ... I created several forms in Excel (not using any templates) and now I am trying to gray out cells, and use the TAB key to easily navigate from cell to cell that requires inputted data. I cannot figure out how to do this, like I have done in MS Word before. Suggestion and help much appreciated! Angela Davis |
Trying to gray out cells, and use the TAB key to easily navigate
Sorry, I just couldnt think of a streamlined subject title for what I was
trying to do. thank you "Don Guillett" wrote: A meaningful subject line along with losing the ASAP since all requests here are urgent will help you. Look in the help section or the archives for PROTECTION. -- Don Guillett SalesAid Software "AngelaD" wrote in message ... I created several forms in Excel (not using any templates) and now I am trying to gray out cells, and use the TAB key to easily navigate from cell to cell that requires inputted data. I cannot figure out how to do this, like I have done in MS Word before. Suggestion and help much appreciated! Angela Davis |
EXCEL HELP ASAP!!!
Angela
See Bob Phillips' site for info on using a named range or sheet protection. http://www.xldynamic.com/source/xld.xlFAQ0008.html There is also sheet_change code that will leap around in any order you like. If you want an example of that, post back. Gord Dibben MS Excel MVP On Thu, 4 Jan 2007 11:05:02 -0800, AngelaD wrote: I created several forms in Excel (not using any templates) and now I am trying to gray out cells, and use the TAB key to easily navigate from cell to cell that requires inputted data. I cannot figure out how to do this, like I have done in MS Word before. Suggestion and help much appreciated! Angela Davis |
Trying to gray out cells, and use the TAB key to easily navigate
Angela
See answer at your original post.....the one with ASAP that Don didn't like. Gord Dibben MS Excel MVP On Thu, 4 Jan 2007 11:51:00 -0800, AngelaD wrote: Sorry, I just couldnt think of a streamlined subject title for what I was trying to do. thank you "Don Guillett" wrote: A meaningful subject line along with losing the ASAP since all requests here are urgent will help you. Look in the help section or the archives for PROTECTION. -- Don Guillett SalesAid Software "AngelaD" wrote in message ... I created several forms in Excel (not using any templates) and now I am trying to gray out cells, and use the TAB key to easily navigate from cell to cell that requires inputted data. I cannot figure out how to do this, like I have done in MS Word before. Suggestion and help much appreciated! Angela Davis |
EXCEL HELP ASAP!!!
Yes! I would love to have that code for sheet_change to leap around in any
order you like. Thanks a bunch! "Gord Dibben" wrote: Angela See Bob Phillips' site for info on using a named range or sheet protection. http://www.xldynamic.com/source/xld.xlFAQ0008.html There is also sheet_change code that will leap around in any order you like. If you want an example of that, post back. Gord Dibben MS Excel MVP On Thu, 4 Jan 2007 11:05:02 -0800, AngelaD wrote: I created several forms in Excel (not using any templates) and now I am trying to gray out cells, and use the TAB key to easily navigate from cell to cell that requires inputted data. I cannot figure out how to do this, like I have done in MS Word before. Suggestion and help much appreciated! Angela Davis |
EXCEL HELP ASAP!!!
Private Sub Worksheet_Change(ByVal Target As Range)
Select Case Target.Address Case "$C$2" Range("A1").Select Case "$A$1" Range("E2").Select Case "$E$2" Range("M3").Select Case "$M$3" Range("D4").Select End Select End Sub This is sheet event code. Right-click on the sheet tab and "View Code" Copy/paste into that sheet module. Adjust ranges and add more to suit. Personally I think it's easier to use the named range approach if you have a lot of cell-leaping to do, although once built, the above code is easy to maintain. Gord On Thu, 4 Jan 2007 13:19:00 -0800, AngelaD wrote: Yes! I would love to have that code for sheet_change to leap around in any order you like. Thanks a bunch! "Gord Dibben" wrote: Angela See Bob Phillips' site for info on using a named range or sheet protection. http://www.xldynamic.com/source/xld.xlFAQ0008.html There is also sheet_change code that will leap around in any order you like. If you want an example of that, post back. Gord Dibben MS Excel MVP On Thu, 4 Jan 2007 11:05:02 -0800, AngelaD wrote: I created several forms in Excel (not using any templates) and now I am trying to gray out cells, and use the TAB key to easily navigate from cell to cell that requires inputted data. I cannot figure out how to do this, like I have done in MS Word before. Suggestion and help much appreciated! Angela Davis |
All times are GMT +1. The time now is 09:14 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com