sName = format(Range("a1").Value,"dd-mm-yy")
worksheets.Add
Activesheet.Name = sName

--
Regards,
Tom Ogilvy

Warren wrote in message
news:kkEUb.185726$5V2.902591@attbi_s53...
Can someone please help?

The macro I am writing reads in a date from Cell A1, which is formatted as
dd/mm/yy. I want to create a new sheet with this date as the name. I
know
that the sheet name cannot have "/" in it. The sheet is protected and I
cannot unprotect it.

So what is the code to read in this date and convert it to a text string
in
the format of dd-mm-yy?

Thanks in advance

Warren