Forum Discussion
kvetrivel
Feb 08, 2023Copper Contributor
How to edit table (Table format) when its locked?
I am trying to develop the table mainly because it will automatically add the formula when I have entered the value in one cell. But the problem is I am not able to edit when the sheet is protected....
NikolinoDE
Feb 08, 2023Platinum Contributor
You could do it with VBA, here's an example
Sub Workbook_Open()
With Sheets("YourSheet")
.Protect userinterfaceonly:=True, Password:="YourPassword", AllowInsertingColumns:=True, AllowInsertingRows:=True
.EnableOutlining = True 'for outline
.EnableAutoFilter = True 'for Autofilter
End With
End Sub
or you can do it the traditional (manual 🙂 way, see attached link.
Lock or unlock specific areas of a protected worksheet
Hope I could help you with these information / links.
I know I don't know anything (Socrates)