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 !!

I think Protection might be a better way to go, rather than VBA. Check out this Dummies article.

Thanks Lugh for your answer,

I' ve seen the options relative to lock the cells selected, but I want only to disable inside them Copy / Paste from toolbar giving the user the possibility to insert manually the values ...