vba - How to change Named Range Scope

Question

When I create a named range through the Name Manager, I'm given the option of specifying Workbook or [worksheet name] scope. But if then want to change scope, the drop-down is grayed out. Is there a way, in either Name Manager or, preferablly, VBA to change the scope of an existing named range?

For example:

• testName refers to 'sheet1'!A1:B2 with scope Workbook. How would I change that to
• testName refers to 'sheet1'!A1:B2 with 'sheet1' scope?

Answer 1

I found the solution! Just copy the sheet with your named variables. Then delete the original sheet. The copied sheet will now have the same named variables, but with a local scope (scope= the copied sheet).

However, I don't know how to change from local variables to global..