ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Stop users pasting data in cells (https://www.excelbanter.com/excel-discussion-misc-queries/135903-stop-users-pasting-data-cells.html)

trainerab

Stop users pasting data in cells
 
I need to stop users from being able to copy and paste data into a range of
cells - I need them to type new data into the cells instead

Using Excel XP and 2003

Mike

Stop users pasting data in cells
 
Hi,

A bit too complicated to explain here so if you follow the link below you
can download a workbook of examples.

http://www.savefile.com/files/571204

Mike


"trainerab" wrote:

I need to stop users from being able to copy and paste data into a range of
cells - I need them to type new data into the cells instead

Using Excel XP and 2003


CC G

Stop users pasting data in cells
 
I found this posting that addresses the issue I'm dealing with in Excel.
However, I'm not able to access the link you provided.

Can you tell me how to prevent users from being able to paste data into
specific cells in an Excel worksheet?

Thanks.

"Mike" wrote:

Hi,

A bit too complicated to explain here so if you follow the link below you
can download a workbook of examples.

http://www.savefile.com/files/571204

Mike


"trainerab" wrote:

I need to stop users from being able to copy and paste data into a range of
cells - I need them to type new data into the cells instead

Using Excel XP and 2003



All times are GMT +1. The time now is 05:39 PM.

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