Creating a Worksheet in VBA

  • Thread starter Thread starter Jako
  • Start date Start date
J

Jako

Hello,

Could anyone please tell me how i can create a new worksheet calle
"Acorn" and have the Tab coloured Orange.

Also in a seperate routine i want to change the Tab colour to blue i
cell A17 contains data.

Thanks in advance
 
Try this

Sub test()
On Error Resume Next
Worksheets.Add.Name = "Acorn"
Sheets("Acorn").Tab.ColorIndex = 46
On Error GoTo 0
End Sub

Blue = 5
 
You must log in or register to reply here.

Ask a Question

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.

Ask a Question

Similar Threads

Excel VBA 0
Conditional formatting with vba 3
Excel 2007 VBA shape fill colour problem 4
Text & Colour Hi-lite of "blank" cell 2
Create a new Worksheet with a few Twists 6
Microsoft Excel VBA: Concatenate without formatting 1
copy a group to a new worksheet 2
Excel High lightng dates in future, today and past 1

Back
Top