View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Kevin Lehrbass Kevin Lehrbass is offline
external usenet poster
 
Posts: 15
Default ALLOWING ONLY DATA INSERTION IN LOCKED CELLS

Here is a link containing a macro which disables copy paste.
I have also sent an email to your hotmail account as requested.
http://www.vbaexpress.com/kb/getarticle.php?kb_id=373
--
Regards,

Kevin Lehrbass

www.spreadsheetsolutions4u.com


"FARAZ QURESHI" wrote:

I WORK AT A HEAD OFFICE.
IS THERE ANY WAY BY WHICH I CAN LOCK MY CELLS BUT ALLOW THE BRANCH MANAGERS
FOR DATA FEEDING ONLY BY KEYBOARD AND NOT BY PASTING SO AS TO SECURE MY
COMPLETE FORMAT.
PLEASE MAIL SUGGESTION AT: