Excel buttons stop working when shared over email

[built4thekill]

Hi all,

need some help. I recently created a workbook/tool which ahd a Paste button and Clear All button included. They work fine on my PC however when I share it via email and my colleagues try everything works (all other macros) but those two buttons. Any idea why this could be happening? I saved them to This Workbook when creating them.

 

[built4thekill]

Are you doing the following?
- copying to clipboard in another app
- clicking on cell in sheet
- clicking on PasteValues Button

If you are ...
- delete your original macro
- place code below in a module like Module1
- assign PasteValues to the Button

Sub PasteValues()
    ActiveSheet.PasteSpecial Format:="Unicode Text", Link:=False, DisplayAsIcon:=False
End Sub

That's brilliant thank you!! really appreciate your help