davidm Wrote:
Comment out the line(s) of code that triggers off the message.

I don't have a code to trigger the prompt. Below is the code where the
prompt takes place.

Workbooks.Open Filename:="I:\SECURED\B&H Reconciliations\" &
Range("K5").Value & ".xls"
Selection.Copy
ActiveWindow.Close
Sheets("Submit").Select
ActiveSheet.PasteSpecial Format:="Unicode Text", Link:=False, _
DisplayAsIcon:=False

After the activewindow.close it then issues the prompt.

Thanks for the advice!

More help needed please...


--
miwarren
------------------------------------------------------------------------
miwarren's Profile: http://www.excelforum.com/member.php...o&userid=24682
View this thread: http://www.excelforum.com/showthread...hreadid=437380