Excel buttons stop working when shared over email

built4thekill

New Member
Joined
Oct 26, 2020
Messages
22
Office Version
  1. 365
Platform
  1. Windows
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

New Member
Joined
Oct 26, 2020
Messages
22
Office Version
  1. 365
Platform
  1. Windows
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

VBA Code:
Sub PasteValues()
    ActiveSheet.PasteSpecial Format:="Unicode Text", Link:=False, DisplayAsIcon:=False
End Sub
That's brilliant thank you!! really appreciate your help
 

Some videos you may like

Excel Facts

Format cells as currency
Select range and press Ctrl+Shift+4 to format cells as currency. (Shift 4 is the $ sign).

Watch MrExcel Video

Forum statistics

Threads
1,122,991
Messages
5,599,235
Members
414,297
Latest member
dalkarl

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
Top