{"id":45632,"date":"2014-05-05T17:14:15","date_gmt":"2014-05-05T16:14:15","guid":{"rendered":"http:\/\/hlrnet.com\/technoblog\/?p=45632"},"modified":"2017-11-17T14:35:24","modified_gmt":"2017-11-17T13:35:24","slug":"delen-van-werkblad-onwijzigbaar-maken","status":"publish","type":"post","link":"https:\/\/hlrnet.com\/technoblog\/inicio\/delen-van-werkblad-onwijzigbaar-maken\/","title":{"rendered":"Delen van werkblad onwijzigbaar maken"},"content":{"rendered":"<p>V. Is het mogelijk om delen van een Excel werkblad onwijzigbaar \/ onbeschrijfbaar\u00c2\u00a0te maken?<\/p>\n<p>A Ja hoor.<\/p>\n<ul>\n<li>Selecteer de cellen die mogen gewijzigd worden, dan <em>Getal, Getalnotatie<\/em><br \/>\n<a href=\"http:\/\/hlrnet.com\/technoblog\/wp-content\/uploads\/2014\/04\/xl-select-opmaakgetal.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-medium wp-image-45633\" src=\"http:\/\/hlrnet.com\/technoblog\/wp-content\/uploads\/2014\/04\/xl-select-opmaakgetal-300x192.png\" alt=\"xl-select-opmaakgetal\" width=\"300\" height=\"192\" srcset=\"https:\/\/hlrnet.com\/technoblog\/wp-content\/uploads\/2014\/04\/xl-select-opmaakgetal-300x192.png 300w, https:\/\/hlrnet.com\/technoblog\/wp-content\/uploads\/2014\/04\/xl-select-opmaakgetal.png 955w\" sizes=\"auto, (max-width: 300px) 100vw, 300px\" \/><\/a><\/li>\n<li>Bij Bescherming, zet <em>Geblokkeerd<\/em> af<\/li>\n<\/ul>\n<p><a href=\"http:\/\/hlrnet.com\/technoblog\/wp-content\/uploads\/2014\/04\/xl-select-opmaakgetal-unlock.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-medium wp-image-45634\" src=\"http:\/\/hlrnet.com\/technoblog\/wp-content\/uploads\/2014\/04\/xl-select-opmaakgetal-unlock-300x247.png\" alt=\"xl-select-opmaakgetal-unlock\" width=\"300\" height=\"247\" srcset=\"https:\/\/hlrnet.com\/technoblog\/wp-content\/uploads\/2014\/04\/xl-select-opmaakgetal-unlock-300x247.png 300w, https:\/\/hlrnet.com\/technoblog\/wp-content\/uploads\/2014\/04\/xl-select-opmaakgetal-unlock.png 571w\" sizes=\"auto, (max-width: 300px) 100vw, 300px\" \/><\/a><\/p>\n<ul>\n<li>En nu kan je het werkblad beveiligen.<br \/>\n<a href=\"http:\/\/hlrnet.com\/technoblog\/wp-content\/uploads\/2014\/04\/xl-select-opmaakgetal-blocksheet1.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-medium wp-image-45635\" src=\"http:\/\/hlrnet.com\/technoblog\/wp-content\/uploads\/2014\/04\/xl-select-opmaakgetal-blocksheet1-300x190.png\" alt=\"xl-select-opmaakgetal-blocksheet1\" width=\"300\" height=\"190\" srcset=\"https:\/\/hlrnet.com\/technoblog\/wp-content\/uploads\/2014\/04\/xl-select-opmaakgetal-blocksheet1-300x190.png 300w, https:\/\/hlrnet.com\/technoblog\/wp-content\/uploads\/2014\/04\/xl-select-opmaakgetal-blocksheet1.png 520w\" sizes=\"auto, (max-width: 300px) 100vw, 300px\" \/><\/a><\/li>\n<li>Geef een wachtwoord, bevestig dat wachtwoord, en je bent er.<br \/>\n<a href=\"http:\/\/hlrnet.com\/technoblog\/wp-content\/uploads\/2014\/04\/xl-select-opmaakgetal-blocksheet2.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-medium wp-image-45636\" src=\"http:\/\/hlrnet.com\/technoblog\/wp-content\/uploads\/2014\/04\/xl-select-opmaakgetal-blocksheet2-300x253.png\" alt=\"xl-select-opmaakgetal-blocksheet2\" width=\"300\" height=\"253\" srcset=\"https:\/\/hlrnet.com\/technoblog\/wp-content\/uploads\/2014\/04\/xl-select-opmaakgetal-blocksheet2-300x253.png 300w, https:\/\/hlrnet.com\/technoblog\/wp-content\/uploads\/2014\/04\/xl-select-opmaakgetal-blocksheet2.png 371w\" sizes=\"auto, (max-width: 300px) 100vw, 300px\" \/><\/a><\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>V. Is het mogelijk om delen van een Excel werkblad onwijzigbaar \/ onbeschrijfbaar\u00c2\u00a0te maken? A Ja hoor. Selecteer de cellen die mogen gewijzigd worden, dan Getal, Getalnotatie Bij Bescherming, zet Geblokkeerd af En nu kan je het werkblad beveiligen. Geef een wachtwoord, bevestig dat wachtwoord, en je bent er.<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"iawp_total_views":0,"footnotes":""},"categories":[104,375,79,391],"tags":[],"class_list":["post-45632","post","type-post","status-publish","format-standard","hentry","category-business","category-excel-office-2010","category-odisee","category-office-2013"],"publishpress_future_action":{"enabled":false,"date":"2026-05-03 20:25:45","action":"delete","newStatus":"draft","terms":[],"taxonomy":"category","extraData":[]},"publishpress_future_workflow_manual_trigger":{"enabledWorkflows":[]},"_links":{"self":[{"href":"https:\/\/hlrnet.com\/technoblog\/inicio\/wp-json\/wp\/v2\/posts\/45632","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/hlrnet.com\/technoblog\/inicio\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/hlrnet.com\/technoblog\/inicio\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/hlrnet.com\/technoblog\/inicio\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/hlrnet.com\/technoblog\/inicio\/wp-json\/wp\/v2\/comments?post=45632"}],"version-history":[{"count":0,"href":"https:\/\/hlrnet.com\/technoblog\/inicio\/wp-json\/wp\/v2\/posts\/45632\/revisions"}],"wp:attachment":[{"href":"https:\/\/hlrnet.com\/technoblog\/inicio\/wp-json\/wp\/v2\/media?parent=45632"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/hlrnet.com\/technoblog\/inicio\/wp-json\/wp\/v2\/categories?post=45632"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/hlrnet.com\/technoblog\/inicio\/wp-json\/wp\/v2\/tags?post=45632"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}