When you write Name Manager, is that the one built into xl2007?

I don't use xl2007 enough to know about it.

But Jan Karel Pieterse's (with Charles Williams and Matthew Henson) Name Manager
does have the ability to globalize and localize names.

You can find it at:
NameManager.Zip from http://www.oaltd.co.uk/mvp

Henry wrote:

Thanks Dave, I understand that but I edited the name what I would meant is
that I did change it and would like the option to then change the scope but
Excel does not allow that to be done.


"Dave Peterson" wrote:

Since you can only have one global name with a particular name, you'll have to
create a new name, then delete the old local name.

Henry wrote:

How can I change a Name scope from local to Global?
I designed a worksheet and duplicated it, along with the Names. I have
edited the names but now those are scoped for that worksheet only. Name
Manager does not allow me to change the scope.

--

Dave Peterson


--

Dave Peterson