View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Eduardo Eduardo is offline
external usenet poster
 
Posts: 2,276
Default How to enable Copy and Paste when the sheet and workbook is protec

Hi,
If the cells are unlocked you should be able to copy and paste

"Yuvraj" wrote:

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