{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["List2","List3","List1"],"not_rendered":{"charts":0,"images":10,"macros":1,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"List2","index":0,"n_rows":96,"n_cols":2,"rows_kept":96,"cut":false,"hidden":false,"merged":[[0,0,0,2]]}
["Hyperlink VBA"]
[]
[]
[]
[]
[]
[null,"Hypertext 1"]
[null,"Set rng = ActiveSheet.Range(\"B2\")"]
[null,"rng.Parent.Hyperlinks.Add Anchor:=rng, _"]
[null," Address:=\"http://JakNaExcel.cz\", _"]
[null," TextToDisplay:=\"JakNaExcel.cz\""]
[]
[]
[null,"Hypertext 2"]
[null,"Set rng = ActiveSheet.Range(\"B3\")"]
[null,"rng.Parent.Hyperlinks.Add Anchor:=rng, _"]
[null," Address:=\"http://JakNaExcel.cz\", _"]
[null," ScreenTip:=\"JakNaExcel.cz\", _"]
[null," TextToDisplay:=\"JakNaExcel.cz\""]
[]
[]
[]
[]
[null,"Odkaz na další list"]
[null,"ActiveCell.FormulaR1C1 = \"=HYPERLINK(\"\"[11f - hyperlink.xlsm]List3!A1\"\",\"\"Klikni\"\")\""]
[]
[]
[]
[]
[]
[]
[null,"Odkaz na další list"]
[null,"    Dim rng As Range"]
[null,"    Set rng = ActiveSheet.Range(\"B4\")"]
[null,"    rng.Parent.Hyperlinks.Add Anchor:=rng, Address:=\"\", SubAddress:= _"]
[null,"        \"List3!B5\", TextToDisplay:=\"Přejdi na list 3\""]
[]
[]
[]
[]
[]
[]
[]
[null,"Odkaz z dalšího listu"]
[null,"    Dim targetSheet As Worksheet"]
[null,"    Dim targetRange As Range"]
[null,"    Dim linkedSheet As Worksheet"]
[null,"    Dim linkRange As Range"]
[]
[null,"    ' Aktivní list kam bude směřovat"]
[null,"    Set targetSheet = ThisWorkbook.Sheets(ActiveSheet.Name)"]
[null,"    ' Buňka do které bude směřovat"]
[null,"    Set targetRange = targetSheet.Range(\"A1\")"]
[]
[null,"    ' List kbe dube umístěn odkaz"]
[null,"    Set linkedSheet = ThisWorkbook.Sheets(\"List3\")"]
[null,"    ' buňka do které bude umístěn odkaz"]
[null,"    Set linkRange = linkedSheet.Range(\"B4\")"]
[]
[null,"    ' vytvoření"]
[null,"    linkedSheet.Hyperlinks.Add Anchor:=linkRange, Address:=\"\", SubAddress:= _"]
[null,"        \"'\" & targetSheet.Name & \"'!\" & targetRange.Address, _"]
[null,"        TextToDisplay:=\"Klikni \" & targetSheet.Name"]
[]
[]
[]
[]
[null,"Mazání hypertextových odkazů"]
[]
[null,"Range(\"A3\").Hyperlinks.Delete"]
[]
[null,"Selection.Hyperlinks.Delete"]
[]
[]
[]
[]
[null,"Otvírání složek"]
[]
[null,"Otevři složku"]
[]
[null,"    Range(\"B79\").Select"]
[null,"    ActiveSheet.Hyperlinks.Add Anchor:=Selection, Address:=\"..\\01-VBA\", _"]
[null,"        TextToDisplay:=\"Otevři složku\""]
[]
[]
[]
[null,"    Range(\"B85\").Select"]
[null,"    ActiveSheet.Hyperlinks.Add Anchor:=Selection, Address:=\"aaa\", _"]
[null,"        TextToDisplay:=\"Otevři složku\""]
[]
[]
[]
[null,"Emaily"]
[]
[null,"    ActiveSheet.Hyperlinks.Add Anchor:=Selection, Address:= _"]
[null,"        \"mailto:pavel@example.com?subject=Test\", TextToDisplay:=\"email\""]

{"sheet":"List3","index":1,"n_rows":4,"n_cols":2,"rows_kept":4,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[null,"Klikni List2"]

{"sheet":"List1","index":2,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}