Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Creating a Worksheet in VBA
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 -- Message posted from http://www.ExcelForum.com |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Creating a Worksheet in VBA
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 -- Regards Ron de Bruin http://www.rondebruin.nl "Jako " wrote in message ... Hello, Could anyone please tell me how i can create a new worksheet called "Acorn" and have the Tab coloured Orange. Also in a seperate routine i want to change the Tab colour to blue if cell A17 contains data. Thanks in advance. --- Message posted from http://www.ExcelForum.com/ |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Creating a list from a different worksheet | Excel Discussion (Misc queries) | |||
Creating a Worksheet | Excel Discussion (Misc queries) | |||
Creating a worksheet in Spanish | Excel Discussion (Misc queries) | |||
Creating a new worksheet from another | Excel Programming | |||
Creating a copy of a worksheet | Excel Programming |