Execution interrupted message after new code added

ipbr21054

Well-known Member
Joined
Nov 16, 2010
Messages
5,832
Office Version
  1. 2007
Platform
  1. Windows
Morning all,
Yesterday i added the code supplied below.
I also was using the worksheet after for quite some time without any errors etc.

This morning when i come to use the same worksheet i see the following error message.
Code execution has been interrupted.

I removed the code that was added,saved etc but still this message appears.



Code:
Private Sub CommandButton1_Click()



    If IsNumeric(txtInvoiceNumber) Then
    
        CreateObject("Shell.Application").Open "C:\Users\Ian\Desktop\REMOTES ETC\DR COPY INVOICES\" & txtInvoiceNumber.Value & ".pdf"
    Else
    
        MsgBox "Invoice N/A For This Customer"
    End If


End Sub

Do you see any reason for this.

Many thanks
 

Excel Facts

Fastest way to copy a worksheet?
Hold down the Ctrl key while dragging tab for Sheet1 to the right. Excel will make a copy of the worksheet.
Ive seen these phantom break points before but cant for the life of me remember how ive fixed them. Try having a google around for other peoples experiences and try their solutions. Thats what you appear to have.
 
Upvote 0
Thanks,
I will see what i can find and maybe somebody might reply also.

Cheers
 
Upvote 0
I found a post that you had to press Ctrl & Pause/Break twice at the same time then save.
Restart worksheet & haven`t seen the error since.

Thanks
 
Upvote 0

Forum statistics

Threads
1,224,825
Messages
6,181,190
Members
453,020
Latest member
Mohamed Magdi Tawfiq Emam

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top