Home |
Search |
Today's Posts |
#3
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
A colleague gave me the solution:
The worksheet was protected to prevent writing, but needed unprotection to do a "find and replace". Solution, unlock the relevant column for the "find and replace", therefore, the macro doesn't need to unprotect the entire sheet. All columns are protected but that one. case closed :-) PUBA |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Can't edit a Comment, not protecting, not sharing | Excel Discussion (Misc queries) | |||
Sharing and protecting sections of a worksheet. | Excel Discussion (Misc queries) | |||
.csv incompatible message after saving | Excel Worksheet Functions | |||
Macros incompatible for different versions? | Excel Programming | |||
Incompatible Code | Excel Programming |