ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Paste text only (https://www.excelbanter.com/excel-programming/292271-re-paste-text-only.html)

Bob Phillips[_6_]

Paste text only
 
Matt,

There is a 'Paste Values' command that you can add to the formatting
toolbar, it's in ToolsCustomizeCommandsEdit. Then it is just a click
away.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"Matt" wrote in message
...
Since it seems to be quite an ordeal to turn off cut/copy/paste from a

user, is it possible only to allow the user to paste the cell value but not
the formatting? If this is not possible, can someone tell me a good place
to find code to turn off the cut/copy/paste. I have looked and didn't have
alot of luck. Thanks.




All times are GMT +1. The time now is 04:26 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com