LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
sam sam is offline
Junior Member
 
Posts: 2
Default disabling the copy paste function in a cell

Is there anyway to disable the copy/paste function in a cell in an excel spreadsheet but still be able to edit/type in the same cell?

For example, I want to set up a data entry spreadsheet where a user has to enter the same information twice (example - cell A1 and B1) to stop keying errors, there is a warning message in cell C1 that warns if cells A1 and B1 do not match but i do not want the user to simpily copy and paste the contents of A1 into B1, therefore negating the purpose ok the check column.

Any ideas would be a great help.

Thanks

Sam
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I copy a function with a called cell constant? MitchCarter1957 Excel Worksheet Functions 1 September 6th 05 05:26 PM
Copy Function Genie Bohn Excel Discussion (Misc queries) 0 March 23rd 05 12:28 AM
sending data from one cell to another (not using copy & paste) Charlie Payne Excel Worksheet Functions 3 December 6th 04 03:28 PM
copy a cell value not its function KC Mao Excel Discussion (Misc queries) 2 December 4th 04 04:30 AM
copy paste cell character limit Fred Excel Discussion (Misc queries) 1 December 2nd 04 08:58 PM


All times are GMT +1. The time now is 02:09 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"