Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Change Sheet Name
I need a macro to change my sheet name.
When i open my workbook it allways have a different sheet name everyday(the sheet names are not constant) so i need to change it to as i require (change to Rec), i my workbook i will have only one sheet. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Change Sheet Name
I'm not sure I understand why your sheet's name changes; but, since you only
have one sheet in the workbook, you can just assign whatever name you want to the Name property of the ActiveSheet... ActiveSheet.Name = "Rec" -- Rick (MVP - Excel) "Ranjith Kurian" wrote in message ... I need a macro to change my sheet name. When i open my workbook it allways have a different sheet name everyday(the sheet names are not constant) so i need to change it to as i require (change to Rec), i my workbook i will have only one sheet. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Copy Sheet causes Combo Box change event to fire on original sheet | Excel Programming | |||
how to change formula in shared sheet without loss of change histo | Excel Worksheet Functions | |||
Change workbook sheet reference using cell A1 to change a vairable | Excel Worksheet Functions | |||
How to record a sheet change showing row column sheet name and date? | Excel Programming | |||
How to record a sheet change showing row column sheet name and date? | Excel Programming |