Finding Links

M

mark1

I have a HUGE workbook that has links to another
workbook. I need to find the cell(s) that are linked to
the other workbook. How do I do it quickly and easily?
Thanks in advance!!

PS - Or is there a way to turn off the warning message
that comes up when you open the workbook: "This workbook
contains links to information in another workbook. Would
you like to update it?"
 
D

Dick Kusleika

Mark1

Modal means that the user can't do anything until a dialog is terminated.
Like the File-Print dialog - when that's showing you can't do anything but
work with that dialog.

NonModal (aka modeless) means the opposite. You can work with other object
while the nonmodal form is showing. If you've ever used controls from the
Control Toolbox, like a listbox or commandbutton, and shown the properties
dialog, the you've used a nonmodal dialog. With the properties dialog
showing you can work normally in Excel and switch back to the properties box
when you want to.

I have no idea why people call it modeless. It should be modalless, but I
just call it nonmodal.
 
Top