allow insert of comments but not moving of charts?

[joeq]

I know that by protecting the workbook and specifying EDIT OBJECTS the user is still allowed to insert a comment. but here's my questions....

1. Is there a way to allow only the VBA code to insert comments, but not the user?

2. This one may be asnswered by answering #1 - is there a way to allow the VBA code to insert comments in such as way that will prevent the user from being able to move my charts around? ;(

EDIT OBJECT seems to be a loaf of bread, but I only want to buy a few slices

thanks, joe

 

[erik.van.geit]

1. Is there a way to allow only the VBA code to insert comments, but not the user?

Hi,

within code you can
1. unprotect your sheet
2. add the comment
3. protect the sheet

Sub test()
ActiveSheet.Unprotect "password"
Range("A1").Cells.NoteText "comment generated by macro ""test"""
ActiveSheet.Protect "password"
End Sub

kind regards,
Erik