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

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


--
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

Hi Vikas,

How did you solve the problem?

Regards,
Howard

"vikas.bhandari"
<vikas.bhandari.25wmay_1144430101.2259@excelforu m-nospam.com wrote in
message news:vikas.bhandari.25wmay_1144430101.2259@excelfo rum-nospam.com...

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

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

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
------------------------------------------------------------------------
vikas.bhandari's Profile: http://www.excelforum.com/member.php...o&userid=33276
View this thread: http://www.excelforum.com/showthread...hreadid=530996

whippyyyyyyyyyyyyyy i found it thanks.....


--
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