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, |
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 |