ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   CHANGE PROTECTED CELL VIA MACRO (https://www.excelbanter.com/excel-programming/284875-change-protected-cell-via-macro.html)

SUNIL

CHANGE PROTECTED CELL VIA MACRO
 
Hi

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

Response will be much appreciated.
Thanks



Colo[_7_]

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/



All times are GMT +1. The time now is 02:58 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com