CHANGE PROTECTED CELL VIA MACRO

S

SUNIL

Hi

Is it possible to change cell A1 from a macro if sheet and cell are
protected?

Response will be much appreciated.
Thanks
 
C

Colo

SUNIL said:
*Hi

Is it possible to change cell A1 from a macro if sheet and cell are
protected?

Response will be much appreciated.
Thanks *
Click to expand...

Possible if you know the password.
You can unprotect worksheet and cell via macro.

Why don't you use "UserInterfaceOnly" when you protect the worksheet?
;)
 
Top