View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Colo[_7_] Colo[_7_] is offline
external usenet poster
 
Posts: 1
Default CHANGE PROTECTED CELL VIA MACRO


SUNIL wrote:
*Hi

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

Response will be much appreciated.
Thanks *


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?
;)


---
~~ Message posted from http://www.ExcelForum.com/