I have a textbox (from the drawing toolbar) that I do not want the user to be able to format. Logically, I have locked the textbox but left the "lock text" as false. I want the user to be able insert drawings so when I protect the sheet I allow users to edit objects. Is there a property to not allow a specific shape to be edited (except for it's text) when the "edit objects" are allowed in the protect options? Here is what I have so far:
I have checked the MSDN library at:
http://msdn.microsoft.com/en-us/library/aa174301(office.11).aspx
But I don't think I see the property I am looking for.
Summary:
I don't want users to be allowed to edit one particular shape ("Narrative").
I want users to be allowed to insert drawings
Code:
Private Sub Worksheet_Activate()
With ActiveSheet.Shapes("Narrative")
.Width = 281
.Height = 281
.TextFrame.HorizontalAlignment = xlHAlignJustify
End With
End Sub
I have checked the MSDN library at:
http://msdn.microsoft.com/en-us/library/aa174301(office.11).aspx
But I don't think I see the property I am looking for.
Summary:
I don't want users to be allowed to edit one particular shape ("Narrative").
I want users to be allowed to insert drawings