Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Highlight Cell Help
I was looking for a way to highlight a cell that i am currently going to type
in. After looking through this forum i have seen the suggestion of "rowliner". i downloaded it and it is doing what it suggests however, I desire my worksheet to be protected but it doesn't work once i protect the worksheet. what do i do? i only want to highlight cells that are unlocked for the user as i tab through the worksheet. make sense?? thanks. LTOSH |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Highlight Cell Help
Hi
You have to unprotect the sheet, change formatting af re-protect the sheet. Dim LastCell As Range Private Sub Worksheet_SelectionChange(ByVal Target As Range) ActiveSheet.Unprotect Password:="JustMe" If Not LastCell Is Nothing Then LastCell.Interior.ColorIndex = 0 End If If Target.Locked = False Then Target.Interior.ColorIndex = 4 End If Set LastCell = Target ActiveSheet.Protect Password:="JustMe" End Sub Regards, Per "LTOSH" skrev i meddelelsen ... I was looking for a way to highlight a cell that i am currently going to type in. After looking through this forum i have seen the suggestion of "rowliner". i downloaded it and it is doing what it suggests however, I desire my worksheet to be protected but it doesn't work once i protect the worksheet. what do i do? i only want to highlight cells that are unlocked for the user as i tab through the worksheet. make sense?? thanks. LTOSH |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Highlight Cell Help
See this link:
http://datapigtechnologies.com/blog/...ow-and-column/ Regards, Dan "LTOSH" wrote: I was looking for a way to highlight a cell that i am currently going to type in. After looking through this forum i have seen the suggestion of "rowliner". i downloaded it and it is doing what it suggests however, I desire my worksheet to be protected but it doesn't work once i protect the worksheet. what do i do? i only want to highlight cells that are unlocked for the user as i tab through the worksheet. make sense?? thanks. LTOSH |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Highlight Cell Help
Can you please tell me where I am supposed to go to type in the information
you provided. I understand the unprotect the sheet but don'tunderstand about change formatting of re-protect the sheet. "Per Jessen" wrote: Hi You have to unprotect the sheet, change formatting af re-protect the sheet. Dim LastCell As Range Private Sub Worksheet_SelectionChange(ByVal Target As Range) ActiveSheet.Unprotect Password:="JustMe" If Not LastCell Is Nothing Then LastCell.Interior.ColorIndex = 0 End If If Target.Locked = False Then Target.Interior.ColorIndex = 4 End If Set LastCell = Target ActiveSheet.Protect Password:="JustMe" End Sub Regards, Per "LTOSH" skrev i meddelelsen ... I was looking for a way to highlight a cell that i am currently going to type in. After looking through this forum i have seen the suggestion of "rowliner". i downloaded it and it is doing what it suggests however, I desire my worksheet to be protected but it doesn't work once i protect the worksheet. what do i do? i only want to highlight cells that are unlocked for the user as i tab through the worksheet. make sense?? thanks. LTOSH |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Highlight Cell Help
Thanks Dan however this link is to highlight both a row and column. i only
want to highlight an unlocked cell when worksheet is protected. "Dan" wrote: See this link: http://datapigtechnologies.com/blog/...ow-and-column/ Regards, Dan "LTOSH" wrote: I was looking for a way to highlight a cell that i am currently going to type in. After looking through this forum i have seen the suggestion of "rowliner". i downloaded it and it is doing what it suggests however, I desire my worksheet to be protected but it doesn't work once i protect the worksheet. what do i do? i only want to highlight cells that are unlocked for the user as i tab through the worksheet. make sense?? thanks. LTOSH |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Highlight Cell Help
My RowLiner add-in, and other similar add-ins floating around the net,
use drawing tools to draw shapes on the worksheet to highlight the cell or draw the lines. This can't be done on a protected worksheet. Cordially, Chip Pearson Microsoft Most Valuable Professional Excel Product Group, 1998 - 2009 Pearson Software Consulting, LLC www.cpearson.com (email on web site) On Sun, 4 Oct 2009 12:23:01 -0700, LTOSH wrote: I was looking for a way to highlight a cell that i am currently going to type in. After looking through this forum i have seen the suggestion of "rowliner". i downloaded it and it is doing what it suggests however, I desire my worksheet to be protected but it doesn't work once i protect the worksheet. what do i do? i only want to highlight cells that are unlocked for the user as i tab through the worksheet. make sense?? thanks. LTOSH |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
Highlight Cell Help
thanks for the explanation but again i refer back to my original question.
How do you highlight or color fill a cell that you are about to type in and be able to protect your worksheet? "Chip Pearson" wrote: My RowLiner add-in, and other similar add-ins floating around the net, use drawing tools to draw shapes on the worksheet to highlight the cell or draw the lines. This can't be done on a protected worksheet. Cordially, Chip Pearson Microsoft Most Valuable Professional Excel Product Group, 1998 - 2009 Pearson Software Consulting, LLC www.cpearson.com (email on web site) On Sun, 4 Oct 2009 12:23:01 -0700, LTOSH wrote: I was looking for a way to highlight a cell that i am currently going to type in. After looking through this forum i have seen the suggestion of "rowliner". i downloaded it and it is doing what it suggests however, I desire my worksheet to be protected but it doesn't work once i protect the worksheet. what do i do? i only want to highlight cells that are unlocked for the user as i tab through the worksheet. make sense?? thanks. LTOSH |
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
Highlight Cell Help
Your question has been answered, quickly and accurately -- in fact, within
23 minutes of your original post. The fact you don't like the answer doesn't change its efficacy, and won't change what you need to do. You must unprotect the worksheet, apply the highlighting, then reprotect the sheet. A macro was even supplied to allow you to do this easily. You can either have a solution or be stubborn. Your choice. Regards, Fred. "LTOSH" wrote in message ... thanks for the explanation but again i refer back to my original question. How do you highlight or color fill a cell that you are about to type in and be able to protect your worksheet? "Chip Pearson" wrote: My RowLiner add-in, and other similar add-ins floating around the net, use drawing tools to draw shapes on the worksheet to highlight the cell or draw the lines. This can't be done on a protected worksheet. Cordially, Chip Pearson Microsoft Most Valuable Professional Excel Product Group, 1998 - 2009 Pearson Software Consulting, LLC www.cpearson.com (email on web site) On Sun, 4 Oct 2009 12:23:01 -0700, LTOSH wrote: I was looking for a way to highlight a cell that i am currently going to type in. After looking through this forum i have seen the suggestion of "rowliner". i downloaded it and it is doing what it suggests however, I desire my worksheet to be protected but it doesn't work once i protect the worksheet. what do i do? i only want to highlight cells that are unlocked for the user as i tab through the worksheet. make sense?? thanks. LTOSH |
#9
Posted to microsoft.public.excel.misc
|
|||
|
|||
Highlight Cell Help
Mr. Smith I do not appreciate your tone towards me or my post.
I did try to use the answer to my original post from Per Jessen and it did not work for some reason once i protected it again. That is why I asked for clarification from Per Jessen to where I am suppose to place the information that was provided so i could make sure i was putting that information in the correct location and try to figure out why it did not work for me as you so crassly stated that it should be so easy. If this was easy for me I would not be posting questions on this forum seeking help. As far as the other responses(from Dan and Chip) to my question I was merely answering each one. Just becuase I responded in a way that did not suit you Mr. Smith did not mean in anyway that I did not like the answers that were given. Please be careful not to belittle or judge those who come here seeking help with questions as I am sure I am not the only one who is not fluent in Excel or any other programs that this forum offers help for. Now...I appreciate all the help from those who contribute their knowledge to this site and greatly appreciate their time. LTosh "Fred Smith" wrote: Your question has been answered, quickly and accurately -- in fact, within 23 minutes of your original post. The fact you don't like the answer doesn't change its efficacy, and won't change what you need to do. You must unprotect the worksheet, apply the highlighting, then reprotect the sheet. A macro was even supplied to allow you to do this easily. You can either have a solution or be stubborn. Your choice. Regards, Fred. "LTOSH" wrote in message ... thanks for the explanation but again i refer back to my original question. How do you highlight or color fill a cell that you are about to type in and be able to protect your worksheet? "Chip Pearson" wrote: My RowLiner add-in, and other similar add-ins floating around the net, use drawing tools to draw shapes on the worksheet to highlight the cell or draw the lines. This can't be done on a protected worksheet. Cordially, Chip Pearson Microsoft Most Valuable Professional Excel Product Group, 1998 - 2009 Pearson Software Consulting, LLC www.cpearson.com (email on web site) On Sun, 4 Oct 2009 12:23:01 -0700, LTOSH wrote: I was looking for a way to highlight a cell that i am currently going to type in. After looking through this forum i have seen the suggestion of "rowliner". i downloaded it and it is doing what it suggests however, I desire my worksheet to be protected but it doesn't work once i protect the worksheet. what do i do? i only want to highlight cells that are unlocked for the user as i tab through the worksheet. make sense?? thanks. LTOSH |
#10
Posted to microsoft.public.excel.misc
|
|||
|
|||
Highlight Cell Help
Hi
Place my code in the code sheet for ThisWorkbook. The DIM statement has to be pasted at the very top of the module, ie. above any module. By declaring the variable outside any Sub, the value of the variable can be used next time the macro event fire. My macro unprotect the sheet using the password 'JustMe' then if LastCell has a cell reference remove the highlight from the cell, highlight current cell if locked property is 'False' and protect the sheet again. Hopes this helps. .... Per On 5 Okt., 05:20, LTOSH wrote: Mr. Smith I do not appreciate your tone towards me or my post. * I did try to use the answer to my original post from Per Jessen and it did not work for some reason once i protected it again. *That is why I asked for clarification from Per Jessen to where I am suppose to place the information that was provided so i could make sure i was putting that information in the correct location and try to figure out why it did not work for me as you so crassly stated that it should be so easy. *If this was easy for me I would not be posting questions on this forum seeking help. * As far as the other responses(from Dan and Chip) to my question I was merely answering each one. *Just becuase I responded in a way that did not suit you Mr. Smith did not mean in anyway that I did not like the answers that were given. Please be careful not to belittle or judge those who come here seeking help with questions as I am sure I am not the only one who is not fluent in Excel or any other programs that this forum offers help for. Now...I appreciate all the help from those who contribute their knowledge to this site and greatly appreciate their time. LTosh "Fred Smith" wrote: Your question has been answered, quickly and accurately -- in fact, within 23 minutes of your original post. The fact you don't like the answer doesn't change its efficacy, and won't change what you need to do. You must unprotect the worksheet, apply the highlighting, then reprotect the sheet. A macro was even supplied to allow you to do this easily. You can either have a solution or be stubborn. Your choice. Regards, Fred. "LTOSH" wrote in message ... thanks for the explanation but again i refer back to my original question. How do *you highlight or color fill a cell that you are about to type in and be able to protect your worksheet? "Chip Pearson" wrote: My RowLiner add-in, and other similar add-ins floating around the net, use drawing tools to draw shapes on the worksheet to highlight the cell or draw the lines. This can't be done on a protected worksheet. Cordially, Chip Pearson Microsoft Most Valuable Professional * * Excel Product Group, 1998 - 2009 Pearson Software Consulting, LLC www.cpearson.com (email on web site) On Sun, 4 Oct 2009 12:23:01 -0700, LTOSH wrote: I was looking for a way to highlight a cell that i am currently going to type in. *After looking through this forum i have seen the suggestion of "rowliner". *i downloaded it and it is doing what it suggests however, I desire my worksheet to be protected but it doesn't work once i protect the worksheet. what do i do? *i only want to highlight cells that are unlocked for the user as i tab through the worksheet. *make sense?? thanks. LTOSH- Skjul tekst i anfrselstegn - - Vis tekst i anfrselstegn - |
#11
Posted to microsoft.public.excel.misc
|
|||
|
|||
Highlight Cell Help
Thank you so much Per for taking the time to explain what you posted...makes
sense now and works perfectly...I had left out part about the DIM statement. I appreciate your time on this. LTOSH "Per Jessen" wrote: Hi Place my code in the code sheet for ThisWorkbook. The DIM statement has to be pasted at the very top of the module, ie. above any module. By declaring the variable outside any Sub, the value of the variable can be used next time the macro event fire. My macro unprotect the sheet using the password 'JustMe' then if LastCell has a cell reference remove the highlight from the cell, highlight current cell if locked property is 'False' and protect the sheet again. Hopes this helps. .... Per On 5 Okt., 05:20, LTOSH wrote: Mr. Smith I do not appreciate your tone towards me or my post. I did try to use the answer to my original post from Per Jessen and it did not work for some reason once i protected it again. That is why I asked for clarification from Per Jessen to where I am suppose to place the information that was provided so i could make sure i was putting that information in the correct location and try to figure out why it did not work for me as you so crassly stated that it should be so easy. If this was easy for me I would not be posting questions on this forum seeking help. As far as the other responses(from Dan and Chip) to my question I was merely answering each one. Just becuase I responded in a way that did not suit you Mr. Smith did not mean in anyway that I did not like the answers that were given. Please be careful not to belittle or judge those who come here seeking help with questions as I am sure I am not the only one who is not fluent in Excel or any other programs that this forum offers help for. Now...I appreciate all the help from those who contribute their knowledge to this site and greatly appreciate their time. LTosh "Fred Smith" wrote: Your question has been answered, quickly and accurately -- in fact, within 23 minutes of your original post. The fact you don't like the answer doesn't change its efficacy, and won't change what you need to do. You must unprotect the worksheet, apply the highlighting, then reprotect the sheet. A macro was even supplied to allow you to do this easily. You can either have a solution or be stubborn. Your choice. Regards, Fred. "LTOSH" wrote in message ... thanks for the explanation but again i refer back to my original question. How do you highlight or color fill a cell that you are about to type in and be able to protect your worksheet? "Chip Pearson" wrote: My RowLiner add-in, and other similar add-ins floating around the net, use drawing tools to draw shapes on the worksheet to highlight the cell or draw the lines. This can't be done on a protected worksheet. Cordially, Chip Pearson Microsoft Most Valuable Professional Excel Product Group, 1998 - 2009 Pearson Software Consulting, LLC www.cpearson.com (email on web site) On Sun, 4 Oct 2009 12:23:01 -0700, LTOSH wrote: I was looking for a way to highlight a cell that i am currently going to type in. After looking through this forum i have seen the suggestion of "rowliner". i downloaded it and it is doing what it suggests however, I desire my worksheet to be protected but it doesn't work once i protect the worksheet. what do i do? i only want to highlight cells that are unlocked for the user as i tab through the worksheet. make sense?? thanks. LTOSH- Skjul tekst i anførselstegn - - Vis tekst i anførselstegn - |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how to highlight more related cells if cell highlight | Excel Discussion (Misc queries) | |||
Highlight Cell Based Upon Referenced Cell Data | Excel Worksheet Functions | |||
I can't see Highlight cell in Find & Replace Cell | Excel Discussion (Misc queries) | |||
click on one cell to find and highlight a related cell? | Excel Discussion (Misc queries) | |||
Highlight cells with ctrl-click but only un-highlight one cell | Excel Discussion (Misc queries) |