I am working on a utility that loops through every cell and based o
some rules either leaves the formula with no changes, or performs som
modifications on it before putting in back. So far works fine excep
when it finds a direct reference to an external file. If the referenc
is correct, that is both file and sheet exists, then my process ru
well. BUT when it finds the workseet but the name of the sheet doesn'
exist, Excel popsup with a "select sheet" prompt. I don't want that t
happen.
I have disabled alerts and calculation to manual. The effect is th
same as pressing F2 on it and enter. Excel popsup and asks me to selec
a sheet. Since this interrupts my process I would like for Excel jus
to take the link as is, and place the #REF on the cell. This way I ca
loop through all cells non-stop and later deal with those formulas tha
are linking to non-existant sheets.
I had the same problem when the formula was linking to an non-existan
file; Excel would promot to select a file since the "file was no
found". I deviced a workaround this, but I can't find a workaround th
"select sheet" prompt

--
jrfalc
-----------------------------------------------------------------------
jrfalck's Profile: http://www.excelforum.com/member.php...fo&userid=1666
View this thread: http://www.excelforum.com/showthread.php?threadid=31877