macro which changes the name of tab in an excel sheet

  • Thread starter Thread starter vikram
  • Start date Start date
V

vikram

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
 
activesheet.name=range("b4")
or
if lcase(range("b4"))="vikram" then activesheet.name=range("b4")
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Macro for all Excel Workbooks to print to PDF 2
Macro for Creating Word Document!! 5
Macro can not unprotect a sheet in a shared workbook 4
macro to change tab name to file name 5
Copy tab from one spreadsheet to multiple tabs in another spreadsheetwhile retaining the targets spr 15
Create Sheets from a Range and Copy Data on copy Data on newlycreated Sheets with the Sheet Names 2
button names changed on copied sheet 4
changing tab name on the bottom of an Excel sheet by macro 4

Back
Top