ouestque
asked on
Excel VBA: Confirm Reference String
I have the following VBA code: ActiveSheet.Cells(2, 1) = "='C:\Test Folder\[Wkbk_Closed.xlsx]S heet2'!$A$ 1"
If sheet2 does not exist in "Wkbk_Closed.xlsx" A "Select Sheet" dialog appears that asks me to select a sheet.
1) What VBA code do I use to disable the "Select Sheet" dialog.
2) What VBA code do I use to show a messagebox whenever the sheet can't be found (i.e., which initiates the "Select Sheet" dialog in part 1.)
If sheet2 does not exist in "Wkbk_Closed.xlsx" A "Select Sheet" dialog appears that asks me to select a sheet.
1) What VBA code do I use to disable the "Select Sheet" dialog.
2) What VBA code do I use to show a messagebox whenever the sheet can't be found (i.e., which initiates the "Select Sheet" dialog in part 1.)
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER