you can only do this in office 2002 onwards. this goes into the sheet'
code module.
Private Sub Worksheet_Activate()
Me.Tab.ColorIndex = 3 'this would give "Sheet1" a red underline
End Sub
i tried this, and i dont think it is too useful. as it is, when yo
click on a tab, that tab's name is shown with a white background whil
other tabs are greyed out. with this trick, the active tab shows u
with a white background and a red underline.
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.
