LinkBack URL
About LinkBacks
I have the following code that when run locks the worksheet from editing. Can something be added to change the tab color of that worksheet to red ?
Thank you
Please Login or Register to view this content.
I have the following code that when run locks the worksheet from editing. Can something be added to change the tab color of that worksheet to red ?
Thank you
Please Login or Register to view this content.
Add this to your code
Please Login or Register to view this content.
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
Great worked perfectly. What is the number for green so I can add to the unlock code?
That would be
Please Login or Register to view this content.
That works but I don't understand it. My project is getting very close thanks to all of your great help.
You're welcome.
There are a few ways it can be done. I just gave you the one that I knew. You could also use these...
For red
For GreenPlease Login or Register to view this content.
The numbers go from 1 through 56. Here is a link to the numbers and what color they representPlease Login or Register to view this content.
http://dmcritchie.mvps.org/excel/colors.htm
I think the RGB one is a good one for understanding.
{change the activesheet}.{specifically the current tab attributes}.{specifically the color} to equal in RGB format {red green blue in that order} ({no red}, {lots of green}, {no blue})Please Login or Register to view this content.
makes sense right?
I thank you for the education.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks