View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Chip Pearson Chip Pearson is offline
external usenet poster
 
Posts: 7,247
Default Change the sheets (Name)

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/