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. |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Can't copy & paste row inside a protected worksheet
Hi Giloboy,
Right-click the Excel icon at the extreme left of the menu bar Select View Code Paste the following : Sub workbook_open() Me.Sheets("Sheet3").Protect password:= _ "Your Password", UserInterfaceOnly:=True End Sub Save, close and re-open the workbook. Change the password to suit. --- Regards, Norman "giloboy" wrote in message ... 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. |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
Can't copy & paste row inside a protected worksheet
Hi Norman,
I paste: Sub workbook_open() Me.Sheets("Sheet3").Protect password:= _ "Your Password", UserInterfaceOnly:=True End Sub on the right board call Book 1.xls and then Save, close and re-open the workbook. Nothing happen from that point. How do I put a new password? Thank for your help Giloboy "Norman Jones" wrote: Hi Giloboy, Right-click the Excel icon at the extreme left of the menu bar Select View Code Paste the following : Sub workbook_open() Me.Sheets("Sheet3").Protect password:= _ "Your Password", UserInterfaceOnly:=True End Sub Save, close and re-open the workbook. Change the password to suit. --- Regards, Norman "giloboy" wrote in message ... 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. |
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
Can't copy & paste row inside a protected worksheet
Hi Giloboy,
Nothing happen from that point. As written, Sheet3 should be protected. Have you checked this? --- Regards, Norman "giloboy" wrote in message ... Hi Norman, I paste: Sub workbook_open() Me.Sheets("Sheet3").Protect password:= _ "Your Password", UserInterfaceOnly:=True End Sub on the right board call Book 1.xls and then Save, close and re-open the workbook. Nothing happen from that point. How do I put a new password? Thank for your help Giloboy "Norman Jones" wrote: Hi Giloboy, Right-click the Excel icon at the extreme left of the menu bar Select View Code Paste the following : Sub workbook_open() Me.Sheets("Sheet3").Protect password:= _ "Your Password", UserInterfaceOnly:=True End Sub Save, close and re-open the workbook. Change the password to suit. --- Regards, Norman "giloboy" wrote in message ... 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. |
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) |