hellsreach
New Member
- Joined
- Dec 22, 2015
- Messages
- 19
I have a script that uses a Replace to change one link to another sheet in a different file. No matter what I do, the script gives me a Select Sheet dialog box because it cannot find the tab in question (it doesn't exist yet). If I hit "Cancel" is cancels that dialog box and I get a #Ref error which I 100% ok with. Neither Application.DisplayAlerts = False, Application.AskToUpdateLinks = False solves the issue. Unfortunately, I do this replace on dozens of links, so hitting cancel over and over it completely stupid.
What I WANT is to automatically default to Cancel. Can I do that? Like I said, I'm fine with the error. The sheet in question doesn't exist yet, but will in to days following the "rolling." script.
What I WANT is to automatically default to Cancel. Can I do that? Like I said, I'm fine with the error. The sheet in question doesn't exist yet, but will in to days following the "rolling." script.