I use macro for buttons wich on click executes some calculations:
Sub Button1_Click()
Sheets("Sheet_1").Unprotect Password:=""
......
Sheets("Sheet_1").Protect Password:="", UserInterFaceOnly:=True, AllowFormattingCells:=True, Contents:=True
End Sub
I have 3 buttons in Sheet_1 and 2 buttons in Sheet_2. All of them have this lines of code at the beginnig and the end of macro.
Formating of unlocked cells must be possible.
Thanks for your help.
Bookmarks