Renaming excel speadsheet tab with cell data

September 16, 2011 at 21:15:56
Specs: Windows XP
I am trying to rename the spreadsheet tab with data from a cell, such as a name, or number. I have seen some VBS code that said it would do it, but I am uncertain of where to even try to enter that code. I am very new to this and would appricaite any help that can be given.

See More: Renaming excel speadsheet tab with cell data

Report •

September 17, 2011 at 07:27:15
The code will depend on whether you want to name just one sheet based the cell contents or multiple sheets. It will also depend on whether you want it to run automatically or run when the user chooses.

You'll have to deal with the possibility of invalid sheet names, such as duplicates or names with characters that are not allowed to be used in a sheet name.

Give us some more details and we'll see what we can suggest.

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

Report •
Related Solutions

Ask Question