I have a complicated Workbook that includes many, many names. Several of them show up in the Names Manager with a Scope of only the Worksheet where they are first used. I need to change their scope to Workbook. How can I do this?
BTW, this Workbook has recently had many changes, with Worksheets copied from one Workbook to another. I have a feeling that this is the source of this problem, which I haven’t really seen or noticed before.
NEW EDIT: I seem to remember there is a way to refer to the name with the Worksheet scope from another worksheet, maybe by using the name’s Worksheet and the “!” character. This may be easier than changing the scope. I don’t know.
Lou Sander
