Hi,
I have a macro that correctly stops and shows a message box when there is an error opening a file (if the wrong password was used). But when the correct password is used, the file opens and the macro stops instead of continuing. Here is what I have:
On Error GoTo ErrMsg
Workbooks.Open Filename:= _
"T:\MacroFile.xlsx", Password:=Sheet4.Range("B3").Value
Range("A1").Select
Exit Sub
ErrMsg:
MsgBox ("The password is incorrect." & vbLf & "Type the correct password in cell B3 and try again."), , "ALERT!!!"
additional macro tasks follow
Any suggestions would be appreciated.
Thanks,
Phillycheese
Bookmarks