Urgent Please help...

Posted by Anjali on January 09, 2001 1:02 PM

I have two worksheets: "Cell Rules" and "Inventory".

In the "Cell Rules" sheet I have written all the comments
that have to be attached dynamically to the cells in the
"Inventory" sheets.

Now please tell in which event procedure can I set the
comment to a particular cell and in which event procedure
can I deactivate the comments for that cell.

Please tell me the necessary code how to link comments
dynamically to the cells.

TIA
Anjali

Posted by Robert on January 11, 2001 6:03 PM

Use the following code in a macro:

Worksheets(1).Range("E5").AddComment "Current Sales"

Worksheets(1).Range("e5").ClearComments

For Each c in ActiveSheet.Comments
If c.Author = "Jean Selva" Then c.Delete
Next

OK?