Home |
Search |
Today's Posts |
#7
![]() |
|||
|
|||
![]()
You can hide all the comment indicators:
Manually -- Choose ToolsOptions, and on the View tab, for Comments, choose None Or, programmatically, e.g.: Application.DisplayCommentIndicator = xlNoIndicator If the markers are hidden the comments won't pop up Alan wrote: "Debra Dalgleish" wrote in message ... The following code will add a comment to the cell that was changed: '========================= Sub Worksheet_Change(ByVal Target As Excel.Range) Dim oldtext As String Dim newtext As String With Target On Error Resume Next oldtext = .Comment.Text If Err < 0 Then .AddComment End If On Error GoTo 0 newtext = oldtext & " Changed to " & .Text & _ " by " & Application.UserName & " at " & Now & vbLf With .Comment .Text newtext .Visible = True .Shape.TextFrame.AutoSize = True .Visible = True End With End With End Sub '============================ Hi Debra, Out of interest, is there any way to hide the cell comment marker? Obviously we can hide the comment itself, but what about the red triangle marker? Also, can we avoid the comment 'popping' up when the cell is selected with a 'hidden' comment? Both of those are user annoyance issues rather than anything more fundamental. Thanks, Alan. -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Lost my Paste | Excel Discussion (Misc queries) | |||
Displaying value of specific cell within a range, with IF function...? | Excel Discussion (Misc queries) | |||
Amount or Numbers in Words | New Users to Excel | |||
I cant use englisch function names in a swedich version of excel | Excel Discussion (Misc queries) | |||
Counting Function Dilemma | Excel Worksheet Functions |