G
gk.lists
Way back in Nov 2002 this topic was brought up and responded to by JE
McGimpsey who kindly provided a macro for Office X (as shown below) to
keep Excel from turning all links into live hyperlinks. However, this
macro apparently doesn't work in Office 2004, because I've tried
following JEM's instructions, to no avail.
It SO annoys me that the default is "hyperlink on" because I nearly
never need to do that. And yes, I know how to turn off any one link
individually, but I want them to never turn on in the first place, and
when I inherit a workbook with lots of email links for instance, I want
them off, not on, because it's a total time-sink to go through and
individually turn off each one.
Does anyone have a newer version of how to do this?
Thanks!
Gurukarm
(e-mail address removed)
(e-mail address removed)
quoted text, from message
http://groups.google.com/group/micr...q=hyperlink+++default&rnum=4#e908572587276c54
:
Or, you could put this macro in the ThisWorkbook module of your
workbook
(CTRL-click on the title bar and paste the code below into the Visual
Basic
Editor window "ThisWorkbook" that opens. You can delete the empty
Workbook_Open macro if you wish. Then click on the XL icon in the
formula
toolbar to return to XL). From then on, hyperlinks will automatically
be
removed.
Private Sub Workbook_SheetChange(ByVal Sh As Object, _
ByVal Target As Excel.Range)
With Target.Hyperlinks
If .Count Then .Delete
End With
End Sub
If you want this feature on all new workbooks, put the macro in an
empty
workbook and save it *as a template* in the
Microsoft Office X:Office:Startup:Excel:
folder in your Applications folder with the name "Workbook" (no
extension).
This template will then be used for all subsequent new workbooks
(unless you
choose a different template).
McGimpsey who kindly provided a macro for Office X (as shown below) to
keep Excel from turning all links into live hyperlinks. However, this
macro apparently doesn't work in Office 2004, because I've tried
following JEM's instructions, to no avail.
It SO annoys me that the default is "hyperlink on" because I nearly
never need to do that. And yes, I know how to turn off any one link
individually, but I want them to never turn on in the first place, and
when I inherit a workbook with lots of email links for instance, I want
them off, not on, because it's a total time-sink to go through and
individually turn off each one.
Does anyone have a newer version of how to do this?
Thanks!
Gurukarm
(e-mail address removed)
(e-mail address removed)
quoted text, from message
http://groups.google.com/group/micr...q=hyperlink+++default&rnum=4#e908572587276c54
:
Or, you could put this macro in the ThisWorkbook module of your
workbook
(CTRL-click on the title bar and paste the code below into the Visual
Basic
Editor window "ThisWorkbook" that opens. You can delete the empty
Workbook_Open macro if you wish. Then click on the XL icon in the
formula
toolbar to return to XL). From then on, hyperlinks will automatically
be
removed.
Private Sub Workbook_SheetChange(ByVal Sh As Object, _
ByVal Target As Excel.Range)
With Target.Hyperlinks
If .Count Then .Delete
End With
End Sub
If you want this feature on all new workbooks, put the macro in an
empty
workbook and save it *as a template* in the
Microsoft Office X:Office:Startup:Excel:
folder in your Applications folder with the name "Workbook" (no
extension).
This template will then be used for all subsequent new workbooks
(unless you
choose a different template).