Thank you for the answer! I can run the code and get the text box. In my project, I have several excel workbooks with many tabs each. For all of these workbooks, some of the tabs are red, others not. What I would like to do is for each of the tabs in each of the workbooks, extract certain information if the tab color is not red. Most of my workflow is built already, its just that at this moment I can not identify which tabs are red and which are not, so in the end im extracting the info from every tab.
Therefore, what would be your recommendation to overcome this?
Thanks for your time!