how to skip Update Values dialog when links change tonon-existent spreadsheets?
That worked! I knew about that, but didn't think it applied in this situation
Thanks
-
Ken Shaffe
----- Bob Phillips wrote: ----
Ken
Tr
Application.DisplayAlerts = Fals
at the start of your code, and reset to True after
For the fileexits, look at the Dur function in Help
--
HT
Bob Phillip
... looking out across Poole Harbour to the Purbeck
(remove nothere from the email address if mailing direct
"Ken Shaffer" wrote in messag
..
I have a VBA subroutine within an excel spreadsheet which goes throug
several cells containing links to external spreadsheets and changes th
formulas containing those links to point to a different spreadsheet base
o
the date
It works, kinda, except for the annoying popups which occur from trying t
link to non-existing spreadsheets. The title shows "Update Values:" with
spreadsheet link
|