Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Copy & paste to protected sheet | Excel Discussion (Misc queries) | |||
Copy paste Macro in a Protected Sheet | Excel Discussion (Misc queries) | |||
Do not allow Copy/Paste Functionality in a Protected Sheet | Excel Worksheet Functions | |||
How do I enable copy in a protected workbook? | Excel Discussion (Misc queries) | |||
How to copy/paste info into the protected sheet | Excel Discussion (Misc queries) |