| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Can't copy & paste row inside a protected worksheet
My worksheet contain many rows and columns. One of the column is protected
and contain formula. Can I copy one row and paste it elsewhere inside the same worksheet without removing the protection. I try many thing without success. I can do it when my column is not protected but when the column is protected I can't. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Can't copy & paste row inside a protected worksheet
Hi Giloboy,
You could unprotect | copy/paste | reprotect Aternatively, if you protect with the UserInterfaceOnly argument set to True, then you will be able to copy and paste using code. The UserInterfaceOnly argument is not persistent, so you could reset it in the Workbook_Open event. --- Regards, Norman "giloboy" wrote in message ... My worksheet contain many rows and columns. One of the column is protected and contain formula. Can I copy one row and paste it elsewhere inside the same worksheet without removing the protection. I try many thing without success. I can do it when my column is not protected but when the column is protected I can't. |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Can't copy & paste row inside a protected worksheet
Hi Normand,
How do you protect with the UserInterfaceOnly argument set to True, and reset it in the Workbook_Open event. Thanks Giloboy "Norman Jones" wrote: Hi Giloboy, You could unprotect | copy/paste | reprotect Aternatively, if you protect with the UserInterfaceOnly argument set to True, then you will be able to copy and paste using code. The UserInterfaceOnly argument is not persistent, so you could reset it in the Workbook_Open event. --- Regards, Norman "giloboy" wrote in message ... My worksheet contain many rows and columns. One of the column is protected and contain formula. Can I copy one row and paste it elsewhere inside the same worksheet without removing the protection. I try many thing without success. I can do it when my column is not protected but when the column is protected I can't. |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Can't copy & paste row inside a protected worksheet
Hi Normand,
How do you protect with the UserInterfaceOnly argument set to True, and be able to copy and paste using code and reset it in the Workbook_Open event. Thanks Giloboy "Norman Jones" wrote: Hi Giloboy, You could unprotect | copy/paste | reprotect Aternatively, if you protect with the UserInterfaceOnly argument set to True, then you will be able to copy and paste using code. The UserInterfaceOnly argument is not persistent, so you could reset it in the Workbook_Open event. --- Regards, Norman "giloboy" wrote in message ... My worksheet contain many rows and columns. One of the column is protected and contain formula. Can I copy one row and paste it elsewhere inside the same worksheet without removing the protection. I try many thing without success. I can do it when my column is not protected but when the column is protected I can't. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Copy & paste to protected sheet | Excel Discussion (Misc queries) | |||
| Copy/Paste charts as object inside excel | Charts and Charting in Excel | |||
| allow me to copy and paste in a protected worksheet | New Users to Excel | |||
| How to copy/paste info into the protected sheet | Excel Discussion (Misc queries) | |||
| Copy/Paste a protected cell | Excel Discussion (Misc queries) | |||
Hybrid Mode
