PDA

View Full Version : ENABLE COMMENTS BUT PROTECTING OBJECTS



rodrigoraad
06-17-2016, 06:29 AM
Is there a way to enable comments input and editing but protecting objects, such as buttons and images?

offthelip
06-18-2016, 04:59 AM
You can protect the worksheet ( with a password if you want) but tick everything except "Edit Objects" .
google "protect worksheet" and read the Ms office support to learn more.

rodrigoraad
06-28-2016, 07:28 AM
I know that. But doing so I dont "block" my buttons of being changed or deleted. And when I block object editing i can't insert or edit comments.

offthelip
06-28-2016, 08:31 AM
I think the only way you can get round this is by using the worksheet selection change event to unprotect the specific cells where you want to allow comments
for example if there is a comment which can be edited in I4, this will allow you to edit it, any other selection protects the workbook
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If Target.Address = "$I$4" Then
ActiveSheet.Unprotect
Else
ActiveSheet.Protect
End If

End Sub