View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default How can I change a Name scope from local to Global?

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