View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Yuvraj Yuvraj is offline
external usenet poster
 
Posts: 27
Default How to enable Copy and Paste when the sheet and workbook is protected

Hi All,

My application protects all the sheets and the workbook by the
password.

I have couple of cells which are not locked so that the user can enter
the data.

But in these unlocked cell I do not have the right click functionality
or copy paste functionality enabled.

How to enable the copy paste functionality on these unlocked cells
where user can enter the data.

I also want this copy and paste to be enabled so that i can copy the
data from different work book onto these unlocked cells of this
application

Please guide.

Thanks and Regards,

Yuvraj