I am trying to have tabs automatically colored when a certain cell is greater than zero. This would allow me to immediately identify which tab has been edited in a workbook so I don't even have to look at the other tabs. How would I write this into my code? Thank you in advance for the help!
1) Is this supposed to happen on every sheet?
A single ThisWorkbook macro could watch every sheet in the workbook and color tabs accordingly.
2) Almost every sheet?
The one macro could exclude a short list of sheet names.
3) What cell?
4) What value?
5) What colors?
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use theicon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
?None of us is as good as all of us? - Ray Kroc
?Actually, I *am* a rocket scientist.? - JB (little ones count!)
This could get you going,
You only need to check the Red Tabs.
Regards
Please consider:
Be polite. Thank those who have helped you. Then Click on the star icon in the lower left part of the contributor's post and add Reputation. Cleaning up when you're done. If you are satisfied with the help you have received, then Please do Mark your thread [SOLVED] .
Color the tab red when B2 is greater than 0Originally Posted by JBeaucaire
Is B2 a formula or manually entered values?
Put this into the ThisWorkbook module, see if it gives you the behavior you want.
Please Login or Register to view this content.
Oops meant to say cell V2. Either way it is the end of a formula that has been dragged out by part of my code.
Try the code above, edit the cell address accordingly.
That worked perfectly. Thank you so much for your help!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks