Is there a way to have a comment automatically open with the days date next to the user name?
J Josh Jul 21, 2004 #1 Is there a way to have a comment automatically open with the days date next to the user name?
J Jason Morin Jul 21, 2004 #2 You could use a simple macro like this and add it to a button on a toolbar: Sub InsertComment() With ActiveCell .AddComment .Comment.Text Text:="name" & Chr(10) & _ Format(Now, "mm/dd/yy") & Chr(10) .Comment.Visible = True End With End Sub HTH Jason Atlanta, GA
You could use a simple macro like this and add it to a button on a toolbar: Sub InsertComment() With ActiveCell .AddComment .Comment.Text Text:="name" & Chr(10) & _ Format(Now, "mm/dd/yy") & Chr(10) .Comment.Visible = True End With End Sub HTH Jason Atlanta, GA
