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