(Email worksheet) Show MsgBox when failing to save temp file

Hi,

I have created an excel sheet with en email button that send the sheet as an attachment. For this the sheet is saved temporary on C:\ and then deleted once the email has been sent.

For my work laptop I am not able to access C:\ as we have network disks, thus I am not able to use this macro on my latop. If a user of this sheet has the same issue, not being able to save to C:\ I would like a MsgBox to appear notifying them of the error.

However, I am not able to figure out how to do this.

Is anyone able to help?

If anything is unclear just let me know (see below for code)

Thanks,

Timmy

Please Login or Register  to view this content.

Thanks for a quick reply. This really helps a lot, am a beginner when it comes to vba.

Cheers,
Timmy