Hello:
Please refer to atatched file.
I need to change the color of the font to white in cell B3:E3 when i land on Sheet1.
I have tried using the code as shown in sheet1.
Some code is pasted in Sheet1 and other in Module1.
Not sure what i am doing wrong as it does not work.
Please help to resolve and let me know if you have any questions.
Thanks.
Riz
Try this
This will work as well and is a bit cleaner and changes the font color for the range all at once.
Please Login or Register to view this content.
Please Login or Register to view this content.
Last edited by gmr4evr1; 12-13-2015 at 11:30 AM. Reason: Added 2nd code
1N73LL1G3NC3 15 7H3 4B1L17Y 70 4D4P7 70 CH4NG3 - 573PH3N H4WK1NG
You don't have to add Rep if I have helped you out (but it would be nice), but please mark the thread as SOLVED if your issue is resolved.
Tom
Try this:
Please Login or Register to view this content.
One test is worth a thousand opinions.
Click the * Add Reputation below to say thanks.
Hello:
I wanted to make sure that the code gets activated when i land on that sheet.
Thanks
Riz
Hello Guys:
I think i got it.
will test further and let you know if further help is needed.
Thanks a lot
Riz
Change it to this but put it in the worksheet
You might have to remove the other Worksheet_Activate code though.Please Login or Register to view this content.
You're welcome. Thank you for the rep!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks