well just in case you did not get it.


Sub deletescreentip()
Dim cell As Range

On Error Resume Next


For Each cell In Range("a1:a10")

cell.Select

ActiveSheet.Hyperlinks.Add Anchor:=Selection,
Address:="http:\\www.google.com", ScreenTip:="", TextToDisplay:=" whatever
you need to display in cell"


Next cell





End Sub




"David W" wrote in message
...
Does anyone know how to hide the comment box on a hyperlink