Chances are Sheet1 already exists and you cant see it.

Within a macro, try

Sheet1.visible = true
then rename in the common way

OR

Sheet1.name = "yourname"

(no need for the sarcasm)



"vikas.bhandari" wrote:


Hello Friends,

I was making a project in excel, and for that project I have to use the
name as Sheet1 at any cost. I dont want to rename...My frnd did
something with VBA or something I dont know, now I cannot name my sheet
as Sheet 1. It gives me an error message that "Cannot rename a worksheet
to the same name as another sheet, a referenced object library or a
workbook referenced."

I am now Helpless....please help me :o(

Regards,
Vikas Bhandari


--
vikas.bhandari
------------------------------------------------------------------------
vikas.bhandari's Profile: http://www.excelforum.com/member.php...o&userid=33276
View this thread: http://www.excelforum.com/showthread...hreadid=530996