Hi

I can change the active sheets "name" from a macro by using:

ActiveSheet.Name = "newname"

But how do i change the "(Name)" from the macro?

---

Esbe

--
Message posted from http://www.ExcelForum.com

I don't understand your question. Can you provide a few more
details about what you actually want to do.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com

"Esben " wrote in message
...
Hi

I can change the active sheets "name" from a macro by using:

ActiveSheet.Name = "newname"

But how do i change the "(Name)" from the macro?

---

Esben


---
Message posted from http://www.ExcelForum.com/

In the VBAprojects click on a sheet under Microsoft Excel Objects. The
look in the proberties window.
Here the sheets proberties is listed (You know that ;)

(Name) Sheet7 <-- thats the (Name) i want to change.
DisplayPageBreaks False
DisplayRightToLeft False
EnableAutoFilter False
and so on...

I can change it manually. But I want the macro to do it.

---

Esbe

--
Message posted from http://www.ExcelForum.com

Esben,

You're talking about the CodeName of the sheet. Use something
like


ThisWorkbook.VBProject.VBComponents( _
Worksheets("Sheet2").CodeName).Name = "NewCodeName"

See http://www.cpearson.com/excel/codemods.htm for more
information.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com



"Esben " wrote in message
...
In the VBAprojects click on a sheet under Microsoft Excel
Objects. Then
look in the proberties window.
Here the sheets proberties is listed (You know that ;)

(Name) Sheet7 <-- thats the (Name) i want to change.
DisplayPageBreaks False
DisplayRightToLeft False
EnableAutoFilter False
and so on...

I can change it manually. But I want the macro to do it.

---

Esben


---
Message posted from http://www.ExcelForum.com/

Cool it works...

Thank you. ;)

---

Esbe

--
Message posted from http://www.ExcelForum.com