I have a web site I create in Frontpage. It include an Excel spread
sheet that I paste in. Spread sheet contains a column of web address
(URL) but they are not "active" if I highlight them and special save
them as web links they turn blue but are still not "active." There
are a LOT of them, I need to do them as a batch, not one at a time.
Thanks
Gar Enders |
Request for Question Clarification by
rainbow-ga
on
17 Nov 2005 12:42 PST
Please follow these instructions and let me know if this works:
In Excel, click Tools > Macro > Macros.
In the box under "Macro name" enter a name for this macro and then click "Create".
Paste the following in the box:
Sub MakeHyperlinks()
Dim cell As Range
For Each cell In Intersect(Selection, _
Selection.SpecialCells(xlConstants, xlTextValues))
With Worksheets(1)
.Hyperlinks.Add Anchor:=cell, _
Address:=cell.Value, _
ScreenTip:=cell.Value, _
TextToDisplay:=cell.Value
End With
Next cell
End Sub
Exit that window.
In the excel file that contains the hyperlinks you want to activate,
highlight the cells with the hyperlinks.
Click Tools > Macro > Macros.
Highlight the new macro and click "Run."
All the cells with the highlighted hyperlinks should now be active.
Looking forward to your clarification.
Best regards,
Rainbow
|
Clarification of Question by
burbncowby-ga
on
17 Nov 2005 14:50 PST
Hooray
followed instructions and it seems to have worked great. Very pleased.
If you like you can go to my web site and check it out for yourself.
www.garenders.com
then look for quick lists (right near the top) and then Arlington
Condos (the only one I've updated with your macro.
Thanks
This is my first time at this question thing, what next?
|
Clarification of Question by
burbncowby-ga
on
17 Nov 2005 17:23 PST
slight hiccup
I can't seem to figure out how to save the Macro so it is available to
be selected when I open a new spreadsheet.
|
Request for Question Clarification by
rainbow-ga
on
17 Nov 2005 21:39 PST
To save the macro, try this:
Go Tools > Macro > Record Macro.
Enter a name for the Macro and under "Store macro in" select "Personal
Macro Workbook".
The macro should now be available from any Excel workbook you open on the computer.
The explanations on this site should help:
http://www.hamilton.edu/college/its/documentation/Hamilton%20Standard%20Software/MS%20Office/External/TRA-ExcelMacros-ALL.pdf
Looking forward to your clarification.
Best regards,
Rainbow
|
Clarification of Question by
burbncowby-ga
on
18 Nov 2005 07:20 PST
Ok I've got the program running that works and I believe I have saved
it properly, however when I try to run the saved macro I get runtime
error 9 and the following in the debuger:
Sub gar1()
'
' gar1 Macro
' Macro recorded 11/18/2005 by EDGAR R ENDERS
'
' Keyboard Shortcut: Ctrl+g
'
Range("K10").Select
Selection.Hyperlinks(1).Follow NewWindow:=False, AddHistory:=True
Application.WindowState = xlMinimized
ActiveWorkbook.RunAutoMacros Which:=xlAutoClose
End Sub
The line that starts "Selection.Hyperlinks" is in yellow but I still
don't know what the problem is or how to correct it.
Also when I paste your text in the Macro the only way I can make it
work is by deleting the starting and ending text that is there when
the window opens, not by adding your text in between those points. Is
this correct?
Sorry to be so much trouble, appreciate you efforts.
thanks
|
Request for Question Clarification by
rainbow-ga
on
18 Nov 2005 07:58 PST
Thank you for your clarification.
I had no errors running the saved macro. Perhaps you might want to
delete it and save it again.
You said:
"Also when I paste your text in the Macro the only way I can make it
work is by deleting the starting and ending text that is there when
the window opens, not by adding your text in between those points. Is
this correct?"
Yes, this is correct.
You are no trouble at all. :)
Please let me know if you would like me to post the information I have
provided as an answer to your question.
All the best,
Rainbow
|
Clarification of Question by
burbncowby-ga
on
18 Nov 2005 08:49 PST
Well, if you could just hold on a little bit and let me make sure I've
got this saving thing down I would appreciate it.
However, with that said, I think your original reply answered the
question I posted, I will be most happy to pay you for it. I think
would help anyone else with the same problem, presumably people who
use Excel more then I do won't have the same difficulty with some of
the details.
Will get back to you shortly.
Thanks
Gar
|
Request for Question Clarification by
rainbow-ga
on
18 Nov 2005 10:07 PST
I'll wait for you to get back to me.
Good luck,
Rainbow
|
Clarification of Question by
burbncowby-ga
on
18 Nov 2005 16:18 PST
Rainbow,
I think I've got a handle on it now. Feel Free to publish the answer.
This make my site much more effective, and I really appreciate your help.
Gar
|
,
0 Comments
)