#1
|
|||
|
|||
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 !! |
#2
|
||||
|
||||
I think Protection might be a better way to go, rather than VBA. Check out this Dummies article.
|
#3
|
|||
|
|||
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 ... |
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Moving a text range to specific location | Cosmo | Word VBA | 3 | 04-06-2018 05:40 AM |
VBA macro to copy range and paste in next blank row | tune2grow | Excel Programming | 0 | 09-03-2014 08:25 PM |
how to cut and paste for the range | tomlam | Excel Programming | 5 | 12-26-2012 02:20 AM |
disable desktop notifications of incoming emails from a specific address | userman | Outlook | 6 | 07-17-2012 11:34 PM |
Cut and paste a range of cells and preserve formatting | StarWeaver | Excel | 1 | 03-02-2010 01:41 PM |