Code that automatically renames sheet name when I type something in cell A1?

[mystic17x]

Can someone give me the whole code on how to make a sheet that I am currently on to get automatically renamed when I put something in A1, & then when I am on my next sheet & I type something in A1 again, I want it to do the same thing, & so on.

The name that will go into the cells will be as dates, problem is the date formula has slashes & that doesn't register well with the sheet name, so I was wondering if it can grab the dashes that I type in the cell instead like 1-15-2000.

& last but not least lol I was wondering if I can get the code with the error, check, message thingy, u know where if u put a slash, or more than 31 characters, etc., it will tell u there's an error, and u click ok, etc. :-) Thank uuu

O & where do I put this code @? :-)

[humdingaling]

Something like this maybe

Put under Workbook

Please Login or Register  to view this content.

This code should not reach 31 chars issues nor have issues with the slash as it formats to specified format

if sheet already exists it will go to err:

[NeedForExcel]

Here is for the 1st part.. Let me know if it is as required, and I will give the the code with error handlers

Right click on the sheet name and select View Code.. Paste the below code there..

Please Login or Register  to view this content.

Try changing the value in cell A1 and see if it works