Microsoft Office Forums Disable Paste in specific range

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 06-11-2019, 02:10 AM
il_betto il_betto is offline Disable Paste in specific range Windows 10 Disable Paste in specific range Office 2010
Novice
Disable Paste in specific range
 
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
  #2  
Old 06-11-2019, 08:26 AM
Lugh's Avatar
Lugh Lugh is offline Disable Paste in specific range Windows 10 Disable Paste in specific range Office 2016
Advanced Beginner
 
Join Date: May 2019
Location: USA
Posts: 55
Lugh is on a distinguished road
Default

I think Protection might be a better way to go, rather than VBA. Check out this Dummies article.
__________________
Windows 10 Home x64 1803, Office 365 monthly channel
Main MSOs: Word, Excel, Access, OneNote, Outlook
Reply With Quote
  #3  
Old 06-12-2019, 12:06 AM
il_betto il_betto is offline Disable Paste in specific range Windows 10 Disable Paste in specific range Office 2010
Novice
Disable Paste in specific range
 
Join Date: May 2019
Posts: 10
il_betto is on a distinguished road
Default

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 ...
Reply With Quote
Reply

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
Disable Paste in specific range how to cut and paste for the range tomlam Excel Programming 5 12-26-2012 02:20 AM
Disable Paste in specific range disable desktop notifications of incoming emails from a specific address userman Outlook 6 07-17-2012 11:34 PM
Disable Paste in specific range Cut and paste a range of cells and preserve formatting StarWeaver Excel 1 03-02-2010 01:41 PM


All times are GMT -7. The time now is 10:50 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2019, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2019 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft