Convert multiple hyperlinks to buttons

[Legacy 32120]

Hello folks!

Can hyperlinks be converted to buttons please?
I've a large number of links so a global conversion is what I'm hoping for.

Thanks muchly....

Max

P.S. I'm running Excel 2010

 

[Gary McMaster]

Mark,

Can you point me to any info on the RegExp object. I've never seen that before and would like to study it.

Thanks,

Gary

 

[Legacy 32120]

Hi Mark,

Pardon my not being clearer. The converted hyperlinks in the buttons are changed from =HYPERLINK() to full path or embedded type e.g. D:/// etc..
I wondered why the change?
My guess, =HYPERLINK() can't be used with buttons?
Hope that's better?

Cheers mate!

Max

 

[Gary McMaster]

This one seems to be pretty good in case anyone else is interested.

http://msdn.microsoft.com/en-us/library/ms974570.aspx

Gary

 

[GTO]

Hi Gary,

Here are a few links that might interest you:

http://www.aivosto.com/vbtips/regex.html

http://www.regular-expressions.info/index.html

I would have to admit that I have not been able to practice at RegExp near as much as I'd like, and thus, find myself forgetting even basics as to the pattern/special characters and so on. I like this link, as in script free view, you can quickly go to several different related pages. Sort of a help file if you will.

http://msdn.microsoft.com/en-us/library/6wzad2b2(VS.85).aspx

I will no doubt fail to mention several (apologies) but as time permits, I try and read thru the suggestions of PGC01, sanrv1f, and PeterSss whenever I spot them. As mentioned, I am baby-stepping through regexp so far, but they can be awful neat


Hi Max,

I do not think I'd have the expertise to answer as to a why. As to using the worksheet function from from vba (ie - from a button), I would say no. There are a limited number of worksheet functions that are accessable from vba, and hyperlink is not included.

A great day to both,

Mark

 

[Legacy 32120]

Thanks Mark,

That clarifies that for me.

Have a great day as well!

Max

 

[Gary McMaster]

I will no doubt fail to mention several (apologies) but as time permits, I try and read thru the suggestions of PGC01, sanrv1f, and PeterSss whenever I spot them. As mentioned, I am baby-stepping through regexp so far, but they can be awful neat

I do the same. I find studying the work of the masters to be way better than any help file.

Gary