Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Modifying a locked/protected sheet
If I want to add/edit data onto a locked and password
protected sheet (to which I already know the password), should my VBA code first "unprotect" the sheet, add data, then "protect" the sheet again?? Or can my VBA code simply write data onto the protected sheet?? (bypassing the whole lock and unlock procedure) It seems to me that both methods might work....if that is so, would any method be better than the other for any reason??? thankx |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Allowing editing locked cells in a protected sheet in excel | Excel Worksheet Functions | |||
Relacing default Excel message box when user attempts to change locked cell on protected sheet. | Excel Programming | |||
Able to overwrite locked cell in protected sheet | Excel Discussion (Misc queries) | |||
my sheet is locked and protected, i want to insert row with autofo | Excel Programming | |||
Still can select locked cells in protected sheet | New Users to Excel |