hyperlinking a cell in many sheets

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Yabi - 16 Apr 2007 07:46 GMT

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

Reply to this Message

Gary''s Student - 16 Apr 2007 10:28 GMT

First RIGHT-click the link and select Remove Hyperlink from the popup.
Then clear the text if you desire.

Signature

Gary''s Student - gsnu200715

> 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

Reply to this Message

Yabi - 18 Apr 2007 10:12 GMT

On Apr 16, 12:28 pm, Gary''s Student
<GarysStud...@discussions.microsoft.com> wrote:

> First RIGHT-click the link and select Remove Hyperlink from the popup.
> Then clear the text if you desire.
[quoted text clipped - 8 lines]
>
> - 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.

Reply to this Message

Gary''s Student - 18 Apr 2007 13:30 GMT

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.

Signature

Gary''s Student - gsnu200716

> On Apr 16, 12:28 pm, Gary''s Student
> <GarysStud...@discussions.microsoft.com> wrote:
[quoted text clipped - 13 lines]
> I know the steps you mentioned. My question is how to perform that
> action (removing the hyperlink) in more than one sheet.

Reply to this Message

Gord Dibben - 18 Apr 2007 17:41 GMT

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

>Enter and run this small macro:
>
[quoted text clipped - 6 lines]
>
>It will remove ALL hyperlinks in ALL worksheets.

Reply to this Message

Gary''s Student - 18 Apr 2007 18:02 GMT

Thanks.

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

Insert > Hyperlink

Signature

Gary''s Student - gsnu200716

> Depends upon how the hyperlinks were created, I believe.
>
[quoted text clipped - 14 lines]
> >
> >It will remove ALL hyperlinks in ALL worksheets.

Reply to this Message

Gord Dibben - 18 Apr 2007 19:38 GMT

Not that I know of.

Friendly name, yes, screen tip, no.

Gord

>Thanks.
>
>by the way is there any way to add a screentip if =hyperlink() is used
>instead of:
>
>Insert > Hyperlink

Reply to this Message

Gary''s Student - 19 Apr 2007 00:58 GMT

Thanks - looks like I have to stick to comments

Signature

Gary''s Student - gsnu200716

> Not that I know of.
>
[quoted text clipped - 8 lines]
> >
> >Insert > Hyperlink

Reply to this Message

Gord Dibben - 19 Apr 2007 01:12 GMT

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

>Thanks - looks like I have to stick to comments

Reply to this Message

Rate this thread: