ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   macro (https://www.excelbanter.com/excel-programming/372270-macro.html)

holy41

macro
 
I need a macro command to unprotect cells A6:O6. I don't won't to unprotect
the whole Sheet could someone help me ?

Thank Ken

Tom Ogilvy

macro
 
Cells are locked or unlocked - but to change that setting you have to
unprotect the worksheet

Activesheet.Unprotect Password:="ABC"
cells.Locked = True
Range("A6:O6").Locked = False
Activesheet.Protect Password:="ABC"

--
Regards,
Tom Ogilvy


"holy41" wrote:

I need a macro command to unprotect cells A6:O6. I don't won't to unprotect
the whole Sheet could someone help me ?

Thank Ken



All times are GMT +1. The time now is 03:01 AM.

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