| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Using VBE to change tab name
Hi
How do I change the tab name for a worksheet in VBE? -- joeski |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Using VBE to change tab name
worksheets("Sheet1").Name = "Smurf"
-- Regards, Tom Ogilvy "joeski" wrote: Hi How do I change the tab name for a worksheet in VBE? -- joeski |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Using VBE to change tab name
Hi Joeski,
Try: '============= Public Sub Tester004() Sheets("Sheet1").Name = "MySheet" End Sub '<<============= --- Regards, Norman "joeski" wrote in message ... Hi How do I change the tab name for a worksheet in VBE? -- joeski |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| change formula in a shared worksheet without losing change history | Excel Worksheet Functions | |||
| Excel bar chart formatting of bars to change colors as data change | Excel Discussion (Misc queries) | |||
| Use date modified to change format & create filter to track change | Excel Worksheet Functions | |||
| Change workbook sheet reference using cell A1 to change a vairable | Excel Worksheet Functions | |||
| Change Cell from Validated List Not Firing Worksheet Change Event | Excel Programming | |||
Linear Mode
