| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
setting tab name for worksheet
hi.
Cant figure how to set name on diffrent worksheets. any help? thank you regards jan |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
setting tab name for worksheet
Just double click on the sheet tab and start typing the new name. When
finished, hit Enter. Amit "Jan Eikeland" wrote in message ... hi. Cant figure how to set name on diffrent worksheets. any help? thank you regards jan |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
setting tab name for worksheet
in vba
thisworkbook.worksheets("<oldname").name = "<newname" ricky "Jan Eikeland" wrote in message ... hi. Cant figure how to set name on diffrent worksheets. any help? thank you regards jan |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
setting tab name for worksheet
activesheet.name="Whatever"
-- Don Guillett SalesAid Software "Jan Eikeland" wrote in message ... hi. Cant figure how to set name on diffrent worksheets. any help? thank you regards jan |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
setting tab name for worksheet
Jan
Sub sheetname1() ActiveSheet.Name = Format(Now(), "dddd-mmm-yy") End Sub Sub sheetname() ActiveSheet.Name = Range("c1") End Sub Gord Dibben Excel MVP On Thu, 11 Dec 2003 17:21:47 GMT, "Jan Eikeland" wrote: hi. Cant figure how to set name on diffrent worksheets. any help? thank you regards jan |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Setting up a worksheet | Excel Worksheet Functions | |||
| Setting up Excel worksheet | Setting up and Configuration of Excel | |||
| Setting up a worksheet for LOG LOG analysis | Excel Worksheet Functions | |||
| Novice needs help setting up a worksheet | New Users to Excel | |||
| Help with setting up a worksheet funtion | Excel Worksheet Functions | |||
Linear Mode
