From
please let me know![]()
Please Login or Register to view this content.
From
please let me know![]()
Please Login or Register to view this content.
Last edited by baig123; 12-10-2014 at 02:18 AM.
Yep, use your macro recorder.
Select all the cells and unlock them, then lock the cells you want locked and protect the sheet.
For Locking and unlocking, select the Range then right click. select the Format cells option from menu. Under the menu goto Protection Tab.
i am trying to used a VBA
Sub ProtectTheSheet()
Dim chCell As Range
Dim chRng As Range
'Clear the default status
Cells.Locked = False
'replace abcd with your password in all locations.
ActiveSheet.Unprotect "abcd"
'Applied only to column A
Range("A:A").Locked = True
ActiveSheet.Protect "abcd"
End Sub
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks