Hiding Links
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 |
All times are GMT +1. The time now is 12:51 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com