| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
protect cells
I would like to protect some cells to avoid user to modify information.
My copy method fails, if I use protect and unprotect. I use Protection.AllowEditRanges.Add to write information on the cells using VBA. It seems VBA can not copy data in to the cellls which protect and unprotect or AllowEdirRanges. Am I right? If I am wrong please advise me, Any information is great appreciated, |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
protect cells
You are right, you must unprotect before you copy, you can then re-protect
after. -- Cheers Nigel "Souris" wrote in message ... I would like to protect some cells to avoid user to modify information. My copy method fails, if I use protect and unprotect. I use Protection.AllowEditRanges.Add to write information on the cells using VBA. It seems VBA can not copy data in to the cellls which protect and unprotect or AllowEdirRanges. Am I right? If I am wrong please advise me, Any information is great appreciated, |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
protect cells
It seems that AllowEditRanges does not allow copy either.
I need delete AllowEditRange and unprotect spreadsheet to do copy method. "Nigel" wrote: You are right, you must unprotect before you copy, you can then re-protect after. -- Cheers Nigel "Souris" wrote in message ... I would like to protect some cells to avoid user to modify information. My copy method fails, if I use protect and unprotect. I use Protection.AllowEditRanges.Add to write information on the cells using VBA. It seems VBA can not copy data in to the cellls which protect and unprotect or AllowEdirRanges. Am I right? If I am wrong please advise me, Any information is great appreciated, |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| protect cells in excel, but also allow a search in those cells? | Excel Worksheet Functions | |||
| How do I protect cells or a range of cells in excel spreadsheet? | Excel Worksheet Functions | |||
| Protect Cells | Excel Discussion (Misc queries) | |||
| Lock and protect cells without protect the sheet | Excel Programming | |||
| Protect certain cells | Excel Programming | |||
Linear Mode
