Thread
:
Macro change sheet tab color and name
View Single Post
#
8
Posted to microsoft.public.excel.misc
Dave Peterson
external usenet poster
Posts: 35,218
Macro change sheet tab color and name
I don't know what features were added in what versions for Macs.
You may want to post your question he
news://msnews.microsoft.com/microsof...c.office.excel
if you don't get a good response.
Gene Augustin wrote:
Office 2004, Excel 2004, Version 11.5.3, MAC Powerbook G4, OS 10.5.6
On 3/8/09 2:47 PM, in article
, "Dave
Peterson" wrote:
You can only color the worksheet tabs if you're using xl2002 or higher.
What version of excel are you using?
Gene Augustin wrote:
From Shane Devenshire
.ActiveSheet.Tab.ColorIndex = 42
*********
From Sheeloo:
Sheets("QIF").Tab.Color = 255
********
Both codes give error:
Run-time error '438'
Object doesn't support this property or method
Is there an add-in that I should be using?
I have Analysis Toolpac and Analysis Toolpac-VBA installed.
On 3/7/09 9:31 PM, in article
, "Sheeloo" <Click above
to get my email id wrote:
Sub colorSheet()
Sheets(1).Name = "QIF"
Sheets("QIF").Tab.Color = 255
Sheets.Add After:=Sheets(Sheets.Count)
Sheets(2).Name = "IIF"
Sheets("IIF").Tab.Color = 65535
End Sub
--
Dave Peterson
Reply With Quote
Dave Peterson
View Public Profile
Find all posts by Dave Peterson