{"id":1803,"date":"2023-11-03T20:23:05","date_gmt":"2023-11-03T20:23:05","guid":{"rendered":"https:\/\/exceladvisor.org\/nl\/slot\/"},"modified":"2023-12-06T05:50:17","modified_gmt":"2023-12-06T05:50:17","slug":"slot","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/nl\/slot\/","title":{"rendered":"Hoe snel een werkblad in excel vergrendelen?"},"content":{"rendered":"<div class=\"excel-voor-de-inhoud\" id=\"excel-4218524460\"><script type=\"text\/javascript\">\r\n\tatOptions = {\r\n\t\t'key' : 'c1158f160081d6540a8409e6925dab94',\r\n\t\t'format' : 'iframe',\r\n\t\t'height' : 250,\r\n\t\t'width' : 300,\r\n\t\t'params' : {}\r\n\t};\r\n<\/script>\r\n<script type=\"text\/javascript\" src=\"\/\/www.highperformanceformat.com\/c1158f160081d6540a8409e6925dab94\/invoke.js\"><\/script><\/div> <p>In Excel is er een optie om het blad te vergrendelen. Zoals u weet, kunnen we in Excel vier verschillende soorten werkbladen gebruiken, en u kunt al deze werkbladen vergrendelen. Deze tutorial leert ons hoe we de optie &#8220;Blad beschermen&#8221; kunnen gebruiken. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-92692\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-verrouiller-une-feuille.png\" sizes=\"auto, \" srcset=\"\" alt=\"een blad op slot doen\" width=\"764\" height=\"156\"><\/figure><\/div><h2 id=\"h-lock-protect-a-worksheet\" class=\"wp-block-heading\"> Vergrendel \u201cBescherm\u201d een werkblad<\/h2><ol><li> Klik eerst met de rechtermuisknop op het werkbladtabblad en klik vervolgens op &#8216;Blad beveiligen&#8217;. <br><img loading=\"lazy\" decoding=\"async\" title=\"Beschermfolie in 2 klikken\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/2-cliquez-sur-la-feuille-de-protection.png\" sizes=\"auto, \" srcset=\"\" alt=\"2-click-on-protect-sheet\" width=\"453\" height=\"348\"><\/li><li> Selecteer in het <a href=\"https:\/\/exceladvisor.org\/nl\/dialoog-venster\/\">dialoogvenster<\/a> &#8220;Blad beveiligen&#8221; de opties die de gebruiker mag wijzigen. <br><img loading=\"lazy\" decoding=\"async\" title=\"3-kies-welke-opties-gebruikers-kunnen-wijzigen\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/3-choisissez-les-options-que-les-utilisateurs-peuvent-modifier.png\" sizes=\"auto, \" srcset=\"\" alt=\"3-choose-options-that-users-can-edit\" width=\"247\" height=\"412\"><\/li><li> En voer het wachtwoord in dat u wilt toepassen en klik op OK. <br><img loading=\"lazy\" decoding=\"async\" title=\"4-enter-wachtwoord\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/4-entrez-le-mot-de-passe.png\" sizes=\"auto, \" srcset=\"\" alt=\"4-enter-the-password\" width=\"301\" height=\"130\"><\/li><li> Voer vervolgens hetzelfde wachtwoord opnieuw in om te bevestigen en klik vervolgens op OK om de vergrendeling toe te passen. <br><img loading=\"lazy\" decoding=\"async\" title=\"5-wachtwoord opnieuw invoeren om te voldoen\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/5-re-entrer-le-mot-de-passe-pour-se-conformer.png\" sizes=\"auto, \" srcset=\"\" alt=\"5-re-enter-password-to-conform\" width=\"318\" height=\"182\"><\/li><\/ol><p> Wanneer u op OK klikt, wordt het blad vergrendeld met het opgegeven wachtwoord (123456). Wanneer een gebruiker een cel probeert te bewerken, wordt het bericht weergegeven: &#8220;De cel of het diagram dat u probeert te bewerken, bevindt zich op een beveiligd blad. Als u een wijziging wilt aanbrengen, heft u de beveiliging van een blad op. Mogelijk wordt u gevraagd een wachtwoord in te voeren. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-92697\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/6-popup-pour-deproteger-la-feuille.png\" sizes=\"auto, \" srcset=\"\" alt=\"pop-up-om-de-beveiliging-blad op te heffen\" width=\"796\" height=\"162\"><\/figure><\/div><p> Om de beveiliging op te heffen, volgt u dezelfde stappen en voert u het door u opgegeven wachtwoord in (123456). De bladbeveiliging blijft intact, zelfs als u het blad naar een nieuwe of bestaande werkmap verplaatst of kopieert.<\/p><p class=\"qt-tip\"> <strong>Opmerking<\/strong> : u kunt het opgeven van het wachtwoord overslaan, maar het blad vergrendelen. In dit geval heeft de gebruiker het wachtwoord niet nodig om het blad te ontgrendelen. Maar het laken heeft alle bescherming die u hebt opgegeven.<\/p><h2 id=\"h-lock-a-chart-sheet-macro-sheet-or-dialog-sheet\" class=\"wp-block-heading\"> Een grafisch blad, macroblad of dialoogvensterblad vergrendelen<\/h2><p> Zoals ik al zei, kun je alle soorten vellen vergrendelen, en elk vel bevat een aantal items die je met het slot kunt beveiligen.<\/p><h3 id=\"h-chart-sheet\" class=\"wp-block-heading\"> Grafiekblad <\/h3><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-92698\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/7-verrouiller-une-macro-graphique-ou-une-feuille-de-dialogue.png\" sizes=\"auto, \" srcset=\"\" alt=\"een diagrammacro of dialoogvensterblad vergrendelen\" width=\"283\" height=\"244\"><\/figure><\/div><h3 id=\"h-macro-sheet\" class=\"wp-block-heading\"> Macroblad <\/h3><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-92699\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/Feuille-de-macro-a-8-serrures.png\" sizes=\"auto, \" srcset=\"\" alt=\"macroblad vergrendelen\" width=\"291\" height=\"251\"><\/figure><\/div><h3 id=\"h-dialog-sheet\" class=\"wp-block-heading\"> Dialoogblad <\/h3><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-92700\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/9-Verrouiller-la-feuille-de-dialogue.png\" sizes=\"auto, \" srcset=\"\" alt=\"dialoogvensterblad vergrendelen\" width=\"318\" height=\"186\"><\/figure><\/div><p> Zoals u in de bovenstaande voorbeelden kunt zien, is het opgeven van het wachtwoord optioneel in de bladen. <\/p><div class=\"gb-container gb-container-52dfcee1 gb-container-sample-file\"><h2 class=\"gb-headline gb-headline-e289c143 gb-headline-text gb-headline-4f7959c2\"> Haal het Excel-bestand op<\/h2> <a class=\"gb-button gb-button-e88d6bee gb-button-text gb-button-button1\" href=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/feuille-de-verrouillage.xlsx\" rel=\"nofollow\">Downloaden<\/a> <\/div><div class=\"gb-container gb-container-3044ba66 gb-container-mt\"><p class=\"gb-headline gb-headline-b5bb6270 gb-headline-text\"> <strong><a href=\"https:\/\/exceladvisor.org\/nl\/excel-basisbeginselen\/\">Basisbeginselen van Excel<\/a><\/strong> \/ <strong><a href=\"https:\/\/exceladvisor.org\/nl\/werkblad\/\" data-wpil=\"url\">Excel-spreadsheet<\/a><\/strong><\/p><h2 class=\"gb-headline gb-headline-819d540d gb-headline-text gb-headline-mt-heading\"> Meer tutorials <\/h2><div class=\"gb-grid-wrapper gb-grid-wrapper-7f3d805a gb-grid-wrapper-mt-grid\"><div class=\"gb-grid-column gb-grid-column-7495e031\"><div class=\"gb-container gb-container-7495e031\"><ul><li> <a href=\"https:\/\/exceladvisor.org\/nl\/consolideren\/\">Consolideer gegevens uit meerdere spreadsheets<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/nl\/hernoemen\/\">Hernoem het blad in Excel<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/nl\/groep-1\/\">Groepswerkbladen in Excel<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/nl\/naast-elkaar-zien\/\">Bekijk twee bladen naast elkaar in Excel<\/a> <\/li><\/ul><\/div><\/div><div class=\"gb-grid-column gb-grid-column-530ab33a\"><div class=\"gb-container gb-container-530ab33a\"><ul><li> <a href=\"https:\/\/exceladvisor.org\/nl\/weergave\/\">Bekijk een Excel-blad of alle bladen (spreadsheet)<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/nl\/verwijder-1\/\">Verwijder een blad (werkblad) in Excel<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/nl\/duplicaat\/\">Dupliceer een blad of spreadsheet in Excel<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/nl\/link-naar-een-ander-blad\/\">Maak een hyperlink (link) naar een ander spreadsheet<\/a><\/li><\/ul><\/div><\/div><\/div><\/div>","protected":false},"excerpt":{"rendered":"","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"open","ping_status":"closed","template":"","meta":{"ub_ctt_via":"","footnotes":""},"class_list":["post-1803","page","type-page","status-publish","hentry"],"featured_image_src":null,"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v25.4 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Hoe snel een werkblad in Excel vergrendelen?<\/title>\n<meta name=\"description\" content=\"Met deze korte handleiding kunt u in een paar eenvoudige stappen een blad in Excel vergrendelen. Laten we dit controleren...\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/exceladvisor.org\/nl\/slot\/\" \/>\n<meta property=\"og:locale\" content=\"nl_NL\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Hoe snel een werkblad in Excel vergrendelen?\" \/>\n<meta property=\"og:description\" content=\"Met deze korte handleiding kunt u in een paar eenvoudige stappen een blad in Excel vergrendelen. Laten we dit controleren...\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/nl\/slot\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-06T05:50:17+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-verrouiller-une-feuille.png\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Geschatte leestijd\" \/>\n\t<meta name=\"twitter:data1\" content=\"2 minuten\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/exceladvisor.org\/nl\/slot\/\",\"url\":\"https:\/\/exceladvisor.org\/nl\/slot\/\",\"name\":\"Hoe snel een werkblad in Excel vergrendelen?\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/nl\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/nl\/slot\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/nl\/slot\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-verrouiller-une-feuille.png\",\"datePublished\":\"2023-11-03T20:23:05+00:00\",\"dateModified\":\"2023-12-06T05:50:17+00:00\",\"description\":\"Met deze korte handleiding kunt u in een paar eenvoudige stappen een blad in Excel vergrendelen. Laten we dit controleren...\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/nl\/slot\/#breadcrumb\"},\"inLanguage\":\"nl-NL\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/nl\/slot\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"nl-NL\",\"@id\":\"https:\/\/exceladvisor.org\/nl\/slot\/#primaryimage\",\"url\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-verrouiller-une-feuille.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-verrouiller-une-feuille.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/exceladvisor.org\/nl\/slot\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Thuis\",\"item\":\"https:\/\/exceladvisor.org\/nl\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Hoe snel een werkblad in excel vergrendelen?\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/exceladvisor.org\/nl\/#website\",\"url\":\"https:\/\/exceladvisor.org\/nl\/\",\"name\":\"Excel Advisor\",\"description\":\"Uw gids voor datadominantie\",\"publisher\":{\"@id\":\"https:\/\/exceladvisor.org\/nl\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/exceladvisor.org\/nl\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"nl-NL\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/exceladvisor.org\/nl\/#organization\",\"name\":\"Excel Advisor\",\"url\":\"https:\/\/exceladvisor.org\/nl\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"nl-NL\",\"@id\":\"https:\/\/exceladvisor.org\/nl\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/exceladvisor.org\/nl\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/nl\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png\",\"width\":105,\"height\":36,\"caption\":\"Excel Advisor\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/nl\/#\/schema\/logo\/image\/\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Hoe snel een werkblad in Excel vergrendelen?","description":"Met deze korte handleiding kunt u in een paar eenvoudige stappen een blad in Excel vergrendelen. Laten we dit controleren...","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/exceladvisor.org\/nl\/slot\/","og_locale":"nl_NL","og_type":"article","og_title":"Hoe snel een werkblad in Excel vergrendelen?","og_description":"Met deze korte handleiding kunt u in een paar eenvoudige stappen een blad in Excel vergrendelen. Laten we dit controleren...","og_url":"https:\/\/exceladvisor.org\/nl\/slot\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-06T05:50:17+00:00","og_image":[{"url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-verrouiller-une-feuille.png","type":"","width":"","height":""}],"twitter_card":"summary_large_image","twitter_misc":{"Geschatte leestijd":"2 minuten"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/exceladvisor.org\/nl\/slot\/","url":"https:\/\/exceladvisor.org\/nl\/slot\/","name":"Hoe snel een werkblad in Excel vergrendelen?","isPartOf":{"@id":"https:\/\/exceladvisor.org\/nl\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/nl\/slot\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/nl\/slot\/#primaryimage"},"thumbnailUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-verrouiller-une-feuille.png","datePublished":"2023-11-03T20:23:05+00:00","dateModified":"2023-12-06T05:50:17+00:00","description":"Met deze korte handleiding kunt u in een paar eenvoudige stappen een blad in Excel vergrendelen. Laten we dit controleren...","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/nl\/slot\/#breadcrumb"},"inLanguage":"nl-NL","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/nl\/slot\/"]}]},{"@type":"ImageObject","inLanguage":"nl-NL","@id":"https:\/\/exceladvisor.org\/nl\/slot\/#primaryimage","url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-verrouiller-une-feuille.png","contentUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-verrouiller-une-feuille.png"},{"@type":"BreadcrumbList","@id":"https:\/\/exceladvisor.org\/nl\/slot\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Thuis","item":"https:\/\/exceladvisor.org\/nl\/"},{"@type":"ListItem","position":2,"name":"Hoe snel een werkblad in excel vergrendelen?"}]},{"@type":"WebSite","@id":"https:\/\/exceladvisor.org\/nl\/#website","url":"https:\/\/exceladvisor.org\/nl\/","name":"Excel Advisor","description":"Uw gids voor datadominantie","publisher":{"@id":"https:\/\/exceladvisor.org\/nl\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/exceladvisor.org\/nl\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"nl-NL"},{"@type":"Organization","@id":"https:\/\/exceladvisor.org\/nl\/#organization","name":"Excel Advisor","url":"https:\/\/exceladvisor.org\/nl\/","logo":{"@type":"ImageObject","inLanguage":"nl-NL","@id":"https:\/\/exceladvisor.org\/nl\/#\/schema\/logo\/image\/","url":"https:\/\/exceladvisor.org\/nl\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png","contentUrl":"https:\/\/exceladvisor.org\/nl\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png","width":105,"height":36,"caption":"Excel Advisor"},"image":{"@id":"https:\/\/exceladvisor.org\/nl\/#\/schema\/logo\/image\/"}}]}},"yoast_meta":{"yoast_wpseo_title":"","yoast_wpseo_metadesc":"","yoast_wpseo_canonical":""},"_links":{"self":[{"href":"https:\/\/exceladvisor.org\/nl\/wp-json\/wp\/v2\/pages\/1803","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/exceladvisor.org\/nl\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/exceladvisor.org\/nl\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/exceladvisor.org\/nl\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/exceladvisor.org\/nl\/wp-json\/wp\/v2\/comments?post=1803"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/nl\/wp-json\/wp\/v2\/pages\/1803\/revisions"}],"predecessor-version":[{"id":2703,"href":"https:\/\/exceladvisor.org\/nl\/wp-json\/wp\/v2\/pages\/1803\/revisions\/2703"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/nl\/wp-json\/wp\/v2\/media?parent=1803"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}