hyperlinking a cell in many sheets
 

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

hyperlinking a cell in many sheets
 

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

hyperlinking a cell in many sheets
 

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.

hyperlinking a cell in many sheets
 

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.

hyperlinking a cell in many sheets
 

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.

hyperlinking a cell in many sheets
 

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.

hyperlinking a cell in many sheets
 

Not that I know of.

Friendly name, yes, screen tip, no.


Gord

On Wed, 18 Apr 2007 10:02:01 -0700, Gary''s Student
wrote:

Thanks.


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

Insert Hyperlink

hyperlinking a cell in many sheets
 

Thanks - looks like I have to stick to comments
--
Gary''s Student - gsnu200716


"Gord Dibben" wrote:

Not that I know of.

Friendly name, yes, screen tip, no.


Gord

On Wed, 18 Apr 2007 10:02:01 -0700, Gary''s Student
wrote:

Thanks.


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

Insert Hyperlink

hyperlinking a cell in many sheets
 

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

On Wed, 18 Apr 2007 16:58:01 -0700, Gary''s Student
wrote:

Thanks - looks like I have to stick to comments