Hi all,

I have a couple of problems that I cant seem to fix!

Firstly - The following code copies and sends an excel spreadsheet file (containing 3 sheets). The code seems to works on some computers and not on others and I’m getting an error message box (Microsoft Visual Basic with a red circle and a cross in it, and the number 400). The worksheets are protected could this be a contributing factor? (they need to remain protected) I should prolly also mention that the file is sent and recieved between two types of email applications (a government based email platform and outlook).

Secondly - Recent testing of the code has produced a small problem for the email receiver - when the file is opened they’re prompted with a message box to ‘update or not update links’ (an oversight on my behalf - I should have mentioned this to Leith when he wrote the code for me)…. But can a line of code be added asking it ‘not to update’ so the pop up will not occur, or would a paste special (values) be the way to go? I’m new to VBA so I’m not sure how to write this in.

Can anyone help me with these issues? – code below

Please Login or Register  to view this content.