AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |
Back to Blog
Excel file locked for editing error2/13/2023 ![]() ![]() The important code is this part: ActiveSheet.Protect Contents:=False If Target.Address = "$A$1" And Target.Value "" Then Macro to Auto-Lock Cells Private Sub Worksheet_Change(ByVal Target As Range) This needs to be done so that only specific cells that we choose will be locked from editing. ![]() Now, none of the cells in the worksheet are protected, which means that all of the cells in the worksheet will be editable when you go to protect the worksheet.
0 Comments
Read More
Leave a Reply. |