Worksheet Tab - Naming

Not as a normal Excel function

It can be done via a macro

This may get you started. It's a worksheet event macro

http://www.contextures.com/xlvba01.html#Worksheet

VBA Noob

Good morning dave6726

...and welcome to the forum!!

Or am I asking the impossible

Certainly not.

My add-in (available via the link below) has a utility that can rename one, some or all tabs after a range. If you download and install it go to Ultimate > Sheets > Add / Rename Multiple Sheets and go to the Insert / Rename from Cell tab.

HTH

DominicB

Well guys thanks for the help. Been trying to work through them.

VBA Noob, must admit I like yours, seems quite easy. I thought you had cracked it for me, but the name I am trying to put on the sheet comes from another cell via a formula. E.g date from a sheet is 01/01/2007, on the sheet i need naming with that date. I have cell H1 with formula of =Master!C6. In H2 I have formula =H1, with the cell formatted throug Custom to read ddmmm. The result in H2 is 01Jan. Its this that I want to get onto the sheet tab.

If I manually type it in it works. But if I try it as stated above it does not change at all. Any ideas?

But much appreciated to you all. Will try everything in time.

Dave

Hi dave6726

Not quite sure what you're using at the moment to achieve this - if you want to take this further try posting what you've got at the moment to work on. I assume you're using something like :

Please Login or Register  to view this content.

This of course would cause problems as it's attempting to place a "/" in the sheet name which, according to Excel, is just not on.

You need to force Excel to use the format you require from the cell, rather than just reading a straight value. Not sure how this will fit into what you've got, but something like this will work for you :

Please Login or Register  to view this content.

HTH

DominicB

I am using a suggestion above

Please Login or Register  to view this content.

This works fine if I type a value int A7 i.e 04Jul
But not if A7 takes it value from another cell i.e =Sheet1!A1
Although I have formated A7 as Custom ddmmm

Its the result in A7 that I want as the worksheet tab name


Sorry If my explanation is confusing. I did say I was new to it

Hi dave6726

You just need to integrate my line into your existing code, thus :

Please Login or Register  to view this content.

HTH

DominicB