There are some code samples he

Insert a Plain Comment
http://www.contextures.com/xlcomments03.html#Plain

Jack wrote:
Thanks for your help. I noticed that the code you wrote
puts a comment into the active cell but doesn't allow it
to be edited. What would be good is for a comment box to
be pop up awaiting input.

-----Original Message-----

Sub AddOrDeleteComment()
Dim cmt As Comment

If ActiveCell.Comment Is Nothing Then
ActiveCell.AddComment "This is a new comment"
Else
ActiveCell.Comment.Delete
End If

End Sub

For disabling right-click :
Application.CommandBars("Cell").Enabled = False

Amit
"Jack" wrote in

message

...

Hi...

I'm trying to create a macro button that will insert
and/or delete a comment within the active cell without

any

access to the menu toolbars.

Also, how can i disable the right click in a workbook?

--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html