Change the sheets (Name)

E

Esben

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

Chip Pearson

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
 
E

Esben

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