How to enable Copy and Paste when the sheet and workbook is protected

Y

Yuvraj

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Enabling Autofilter and Sorting in a Protected Sheet 2
Protect Data validation cells from copy paste 3
macro to unlock and lock cells in password protected sheet 3
Paste disabled 1
How to prevent Cut&Paste to change style and data validation on protected sheet 1
How to enable Copy/Paste on protected work sheet? 1
Cell in new sheet should always refer to defined cell in another s 8
Data copy locks cell in worksheet 3

Top