hyperlinking a cell in many sheets

  • Thread starter Thread starter Yabi
  • Start date Start date
Y

Yabi

I selected many sheets and click a cell then tried to delete
hyperlink. But it is executed.
Are there some limitations for actions on many sheets (Performing an
action on many sheets has a good name, but I forget it)
TIA, Rasoul Khoshravan
 
First RIGHT-click the link and select Remove Hyperlink from the popup.
Then clear the text if you desire.
 
First RIGHT-click the link and select Remove Hyperlink from the popup.
Then clear the text if you desire.
--
Gary''s Student - gsnu200715





- Show quoted text -
Click to expand...

I know the steps you mentioned. My question is how to perform that
action (removing the hyperlink) in more than one sheet.
 
Enter and run this small macro:

Sub qwerty()
For Each w In Worksheets
w.Activate
Cells.Hyperlinks.Delete
Next
End Sub


It will remove ALL hyperlinks in ALL worksheets.
 
Depends upon how the hyperlinks were created, I believe.

It will not delete those you create with =HYPERLINK(..) Function

Just those created via right-click>hyperlink or Edit>Paste as Hyperlink.


Gord Dibben MS Excel MVP
 
Thanks.


by the way is there any way to add a screentip if =hyperlink() is used
instead of:

Insert > Hyperlink
 
Just 'cause I don't know doesn't mean it can't happen<g>

Did you get any responses over in the programming group?


Gord
 
Back
Top