Macro change sheet tab color and name
Try recording a macro when you do it manually and I bet you'll end up with code
that works fine.
Gene Augustin wrote:
I have a workbook with only one sheet. I want to use a macro to change the
name of that sheet to "QIF" and its color to RED and add a second worksheet
with "IIF" name and color Yellow.
Gene Augustin
--
Dave Peterson
|