I am not able to rename sheet

[vikas.bhandari]

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 (

Regards,
Vikas Bhandari

 

[vikas.bhandari]

well, i got it...no one here is even bother to view my thread...I am at
wrong place I think

But being Courteous, I need to say Thanks to you all for not giving me
the answer.
thank u so much

Regards,Vikas

 

[L. Howard Kittle]

Hi Vikas,

How did you solve the problem?

Regards,
Howard

"vikas.bhandari"

 

[Guest]

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]

Okay, fine!!!!

Let me tell u the truth...i am trying to crack the funda of creating
the excel which I have attached here... can someone please open this
and tell me how can someone create this soft of files??

Plzzzzzzzzzzzzzzzz

 

[vikas.bhandari]

whippyyyyyyyyyyyyyy i found it thanks.....