Hello,
I'm fairly new to VBA scripts, but I'm trying to make a table of contents page, but depending on the tab color and/or name, I wanted it to display something else. Right now, I have:
But what if some of my sheets have different names, like "SAMPLE," and what if I need the "TextToDisplay" command to be TextToDisplay:="='APP" & i & "'!A5" depending on a different sheet color?Please Login or Register to view this content.
Sorry, I hope my question makes sense.
Thanks very much for any help.
Bookmarks