Thread: Disable Paste in specific range
View Single Post
 
Old 06-11-2019, 02:10 AM
il_betto il_betto is offline Windows 10 Office 2010
Novice
  
Join Date: May 2019
Posts: 10
il_betto is on a distinguished road
Default Disable Paste in specific range
Hi to All,


prototipo_pagina_5.xls

in the file attached the purpose is to disable Copy / Paste of the user around a specific range of cells.

In particular, If the user try to copy, from web page or NotePad, an external value and wants to Paste it in the range AN11:AN26 AN28:AN30,
with Ctrl+C and Ctrl+V this operation is forbidden due to the code that correctly works !!

Instead,
if the user repeats the same procedure of Paste external string (from web, notepad, etc..) using the ToolBar function button "Paste", this action is up to now available in the range AN11:AN26 AN28:AN30, and this is not correct ...

Is there a way to disable Paste button in the toolbar only for paste external values in the specific range AN11:AN26 AN28:AN30 ?

Thanks a lot in advance !!
Reply With Quote