shawntanner
New Member
- Joined
- May 4, 2006
- Messages
- 23
Maybe I'm missing something obvious, but...
I've got a workbook that, when opened asks to auto link to another workbook which does not exist. I am trying to make the workbook stop prompting me for this. Of course, the VBA code is password protected by the person who created this and he is no longer with the company.
The name of the file is "Worksheet in Presentation" and the only reference I can find to it is the following defined name:
Name: Flow{then has a square next to it}
refers to: ='[Worksheet in Presentation]#REF'!#REF!
I've tried, of course, to select it and click delete, but nothing happens. There are many other names that refer to #REF that I can delete, but this one won't go away. (I'm guessing the square after the name means something, but I can't find out what.)
Questions:
1) Am I even on the right track to being able to bypass the autolink?
2) Why can't I delete that defined name?
I've got a workbook that, when opened asks to auto link to another workbook which does not exist. I am trying to make the workbook stop prompting me for this. Of course, the VBA code is password protected by the person who created this and he is no longer with the company.
The name of the file is "Worksheet in Presentation" and the only reference I can find to it is the following defined name:
Name: Flow{then has a square next to it}
refers to: ='[Worksheet in Presentation]#REF'!#REF!
I've tried, of course, to select it and click delete, but nothing happens. There are many other names that refer to #REF that I can delete, but this one won't go away. (I'm guessing the square after the name means something, but I can't find out what.)
Questions:
1) Am I even on the right track to being able to bypass the autolink?
2) Why can't I delete that defined name?