Are you adding the comment with VB ?
I obtained this code by simply recording a macro and this is what was
generated. It should give you an idea of how to add to your code.

Range("C7").Select
Range("C7").AddComment
Range("C7").Comment.Visible = False
Range("C7").Comment.Text Text:= _
"This is a test of how to add a comment to a cell"

"thread" wrote:

Hi all,
i'm populate data to an excel file and i active protaction sheet
one of the problem that i cannot figure out is how can i make the
comments appear during the protection as well