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.
--
Gary''s Student - gsnu200715


"Yabi" wrote:

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

On Apr 16, 12:28 pm, Gary''s Student
wrote:
First RIGHT-click the link and select Remove Hyperlink from the popup.
Then clear the text if you desire.
--
Gary''s Student - gsnu200715



"Yabi" wrote:
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, RasoulKhoshravan- Hide quoted text -

- Show quoted text -

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.
--
Gary''s Student - gsnu200716


"Yabi" wrote:

On Apr 16, 12:28 pm, Gary''s Student
wrote:
First RIGHT-click the link and select Remove Hyperlink from the popup.
Then clear the text if you desire.
--
Gary''s Student - gsnu200715



"Yabi" wrote:
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, RasoulKhoshravan- Hide quoted text -

- Show quoted text -

I know the steps you mentioned. My question is how to perform that
action (removing the hyperlink) in more than one sheet.

Depends upon how the hyperlinks were created, I believe.

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

Just those created via right-clickhyperlink or EditPaste as Hyperlink.


Gord Dibben MS Excel MVP


On Wed, 18 Apr 2007 05:30:03 -0700, Gary''s Student
wrote:

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.

Thanks.


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

Insert Hyperlink
--
Gary''s Student - gsnu200716


"Gord Dibben" wrote:

Depends upon how the hyperlinks were created, I believe.

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

Just those created via right-clickhyperlink or EditPaste as Hyperlink.


Gord Dibben MS Excel MVP


On Wed, 18 Apr 2007 05:30:03 -0700, Gary''s Student
wrote:

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.