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 |
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