Excel links klickbar machen

Tue, 02/10/2012 - 11:45
Body
http://www.jerryleventer.com/excel-tutorial-how-to-convert-plain-text-links-into-hyperlinks/ http://www.niallflynn.com/random-news/convert-urls-to-clickable-links-in-excel/ Makro Editor öffnen, ALT+F11 Rechtsklick "Einfügen->Modul" und dort im Fenster folgenden Text rein, speichern.
  1. Public Sub Convert_To_Hyperlinks()
  2.     Dim Cell As Range
  3.     For Each Cell In Intersect(Selection, ActiveSheet.UsedRange)
  4.         If Cell <> "" Then
  5.             ActiveSheet.Hyperlinks.Add Cell, Cell.Value
  6.         End If
  7.     Next
  8. End Sub
Text bzw. Zeilen markieren und Makro anwenden, Alt+f8
Tagging
Add new comment
The content of this field is kept private and will not be shown publicly.

Plain text

  • Allowed HTML tags: <a href hreflang> <em> <strong> <cite> <blockquote cite> <code> <ul type> <ol start type> <li> <dl> <dt> <dd> <drupal-entity data-*>
  • Web page addresses and email addresses turn into links automatically.
  • Lines and paragraphs break automatically.