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

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