| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
macro which changes the name of tab in an excel sheet
need a macro which can change the name of the tab in a excel spreadsheet
according to the requirements like if B4 cell comtains "vikram" then the name of this tab in this excel sheet changes to vikram ur help is highly appreciated thank u so much --- Message posted from http://www.ExcelForum.com/ |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
macro which changes the name of tab in an excel sheet
activesheet.name=range("b4")
or if lcase(range("b4"))="vikram" then activesheet.name=range("b4") -- Don Guillett SalesAid Software "vikram " wrote in message ... need a macro which can change the name of the tab in a excel spreadsheet according to the requirements like if B4 cell comtains "vikram" then the name of this tab in this excel sheet changes to vikram ur help is highly appreciated thank u so much --- Message posted from http://www.ExcelForum.com/ |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
macro which changes the name of tab in an excel sheet
|
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| To display contents of a folder in an excel sheet using Excel MACRO | Excel Worksheet Functions | |||
| How do I put this macro on a EXCEL sheet? | Excel Discussion (Misc queries) | |||
| create a macro to save excel sheet | Excel Worksheet Functions | |||
| excel - macro code to open a protected sheet, enter passowrd, and then protect sheet | Excel Programming | |||
| Excel Macro for multiple sheet ?? | Excel Programming | |||
Linear Mode
