{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Blad1","Blad2","Blad3"],"not_rendered":{"charts":0,"images":0,"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":"Blad1","index":0,"n_rows":23,"n_cols":11,"rows_kept":23,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[null,null,null,null,null,null,"investering"]
[]
[null,null,null,null,null,null,null,null,null,null,"kijk in K5 naar de validatie"]
[null,null,null,null,null,null,null,null,null,null,"instellingen en foutmelding"]
[]
[]
[]
[]
[null,null,null,null,null,"Ik wil graag het volgende toepassen in mijn excel blad; ik heb in G5 de keuze tussen 2 mogelijkheden (investering of exploitatie). "]
[null,null,null,null,null,"Nou wil ik als men investering aanklikt dat cel K5 geblokkeerd wordt om iets in te vullen. En als men kiest voor exploitatie dat men in K5 wel iets kan invullen. Kan iemand mij op weg helpen? "]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"Private Sub Worksheet_Change(ByVal Target As Range)"]
[null,null,null,null,null,null,null,null,null,null,"If Target.Address = \"$G$5\" Then"]
[null,null,null,null,null,null,null,null,null,null,"Range(\"K5\").ClearContents"]
[null,null,null,null,null,null,null,null,null,null,"End If"]
[null,null,null,null,null,null,null,null,null,null,"End Sub"]
[]
[null,null,null,null,null,null,null,null,null,null,"Dit stukje code kun je zien door op Alt en F11 te drukken.=, je bent dan in de VBA omgeving"]

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

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