Named Range launches VB?

  • Thread starter Thread starter Brian
  • Start date Start date
B

Brian

Hi, when I start a brand new workbook, enter some numbers
in a column and attempt to name the range by typing the
name directly into the Name Box (Price), Excel launches VB
and prompts for a password to access the VB file. If I use
any other name for the range, it works fine. If I create
the named range (Price) in Insert-->Name-->Define... it
also works.

But, why when directly typing Price into the Name box,
does it launch VB?

Thanks, please post replies here only.
Brian in NY
 
Typing a name in the Name Box and pressing Enter does a GoTo if the name
exists in the workbook or, secondly, as a sub or function in the VB project.
It only creates a name if it does not exist in either place.
 
Back
Top