Greetings,
I'm working on a workbook that will grab information from another workbook that a user selects. The only problem is that if a named range doesn't exist in the file they're opening the "Select Sheet" dialog opens up. I want to prevent this dialog from opening up at all! Ultimately, if the cell returns a #NAME? error, or any other error for that matter, I will just replace the returned information with "".
To be clear, the "Select Sheet" dialog box is the one that reads "Select the sheet to update values from".
...I know this leads to all sorts of questions but ultimately if I can just disable the "Select Sheet" dialog from opening up that would be great!
Thanks.
I'm working on a workbook that will grab information from another workbook that a user selects. The only problem is that if a named range doesn't exist in the file they're opening the "Select Sheet" dialog opens up. I want to prevent this dialog from opening up at all! Ultimately, if the cell returns a #NAME? error, or any other error for that matter, I will just replace the returned information with "".
To be clear, the "Select Sheet" dialog box is the one that reads "Select the sheet to update values from".
...I know this leads to all sorts of questions but ultimately if I can just disable the "Select Sheet" dialog from opening up that would be great!
Thanks.