Thread: smart tags
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Ardus Petus
 
Posts: n/a
Default smart tags

Paste the following into your Worksheet's code.
Get back to your worksheet and double-click on cell $A$1

HTH
--
AP

'----------------------------------------------------
Private Sub Worksheet_BeforeDoubleClick( _
ByVal Target As Range, _
Cancel As Boolean)

Const MyCellAddr = "$A$1"
Dim c As Comment

If Target.Address < MyCellAddr Then Exit Sub
For Each c In Comments
c.Visible = Not c.Visible
Next c
Cancel = True
End Sub
'--------------------------------------------------------

"scubagal" a écrit dans le message de
...
I would like to create hidden comments that can be viewed when clicking on

a
smart tag. Does anyone know how to do that?