Hi Bob
.....and I did reply to the last question..see here......
http://www.microsoft.com/office/comm...cel.misc&fltr=

....but nobody has come forward with a reply...hence my frustration!!

Can you help??
thanks

"Bob Phillips" wrote:

We have been here before.

I asked two questions, which you haven't answered.

This is the fourth thread you have started on this topic.

If you want help, you have to play your part.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Anthony" wrote in message
...
Hi,
I have the code below that will create a new worksheet and rename it after
todays date. However if the user trys to create a log again , ie for the
same
day, I get this error:-
Run-time error 1004
cannot rename a sheet to the same name as another sheet, a referenced
object
or a workbook referenced by visual basic.

Oh course what I want is a msg box advising the user that one already
exsists ans asking if they wanna view it.

the code I have


Sub Create_log()
Application.ScreenUpdating = False
With Sheets("Log master")
.Visible = True
.Copy After:=Sheets(Sheets.Count)
ActiveSheet.Name = Format(Date, "DDMMM")
.Visible = False
End With
Application.ScreenUpdating = True
End Sub

any help appreciated