{"id":4032,"date":"2024-02-03T06:55:30","date_gmt":"2024-02-03T06:55:30","guid":{"rendered":"http:\/\/www.learnexcelmacro.com\/wp\/?p=4032"},"modified":"2024-02-03T06:55:30","modified_gmt":"2024-02-03T06:55:30","slug":"protect-unprotect-sheet-using-vba","status":"publish","type":"post","link":"https:\/\/vmlogger.com\/excel\/2024\/02\/protect-unprotect-sheet-using-vba\/","title":{"rendered":"Excel Macro : Excel VBA code to Protect OR UnProtect Sheet"},"content":{"rendered":"<p>[et_pb_section fb_built=&#8221;1&#8243; admin_label=&#8221;section&#8221; _builder_version=&#8221;4.16&#8243; da_disable_devices=&#8221;off|off|off&#8221; global_colors_info=&#8221;{}&#8221; da_is_popup=&#8221;off&#8221; da_exit_intent=&#8221;off&#8221; da_has_close=&#8221;on&#8221; da_alt_close=&#8221;off&#8221; da_dark_close=&#8221;off&#8221; da_not_modal=&#8221;on&#8221; da_is_singular=&#8221;off&#8221; da_with_loader=&#8221;off&#8221; da_has_shadow=&#8221;on&#8221;][et_pb_row admin_label=&#8221;row&#8221; _builder_version=&#8221;4.16&#8243; background_size=&#8221;initial&#8221; background_position=&#8221;top_left&#8221; background_repeat=&#8221;repeat&#8221; global_colors_info=&#8221;{}&#8221;][et_pb_column type=&#8221;4_4&#8243; _builder_version=&#8221;4.16&#8243; custom_padding=&#8221;|||&#8221; global_colors_info=&#8221;{}&#8221; custom_padding__hover=&#8221;|||&#8221;][et_pb_text _builder_version=&#8221;4.17.6&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221;]This is a small VBA code to help you in dealing with <strong>Protecting<\/strong> and <strong>UnProtecting<\/strong> the WorkSheet using Excel Macro. Assuming the fact here that you know <i>How to Protect or UnProtect a Sheet using Excel In-Built function <\/i>. For those who do not know protect or unprotect the sheet using Excel inbuilt function, I will give a brief about the same <a href=\"#protect-unprotect-excel-sheet\"> at the end of this Article.<\/a><\/p>\n<h1>Excel Macro to Protect your Sheet<\/h1>\n<p>To protect an Excel WorkSheet, <strong>Worksheet.Protect<\/strong> Method is used. Using this method you will be able to protect your WorkSheet. Let&#8217;s see the Syntax and How to use Worksheet Protect Method in Excel Macro.<\/p>\n<h1>How to use Worksheet Protect Method in Excel Macro<\/h1>\n<h3>Syntax:<\/h3>\n<p><strong>Note: <\/strong> Like <a href=\"https:\/\/vmlogger.com\/excel\/2014\/06\/excel-macro-to-print\/\" target=\"_blank\" rel=\"noopener\"><strong>.PrintOut Method <\/strong><\/a> this method has all Optional parameters too.<\/p>\n<div class=\"alert alert-warning\">\n<i>WorkSheet.Protect(Password, DrawingObjects, Contents, Scenarios, UserInterfaceOnly, AllowFormattingCells, AllowFormattingColumns, AllowFormattingRows, AllowInsertingColumns, AllowInsertingRows, AllowInsertingHyperlinks, AllowDeletingColumns, AllowDeletingRows, AllowSorting, AllowFiltering, AllowUsingPivotTables)<\/i><\/p>\n<h3>Where:<\/h3>\n<hr \/>\n<table width=\"100%\">\n<tr>\n<td>\n<ul>\n<li><strong>Password: (Optional)<\/strong> is the password you want to pass to protect your sheet. If omitted then WorkSheet will be locked without a password and while unprotecting it, user will not be asked for any password.<\/li>\n<li><strong>DrawingObjects: (Optional)<\/strong> This is Boolean type input. Default value is TRUE. True allows to protect all shapes in the Sheet.<\/li>\n<li><strong>Contents: (Optional)<\/strong> This is Boolean type input. Default Value is TRUE. This is Set to TRUE to protect contents of the Worksheet except those cells or range which are set as &#8220;Un-Locked&#8221;.<\/li>\n<li><strong>Scenarios: (Optional)<\/strong> This is Boolean type input. True is to protect scenarios. The default value is True.<\/li>\n<li><strong>UserInterfaceOnly: (Optional)<\/strong> This is Boolean type input. This is set to True to protect the user interface, but not macros. If this argument is omitted, protection applies both to macros and to the user interface.<\/li>\n<li><strong>AllowFormattingCells: (Optional)<\/strong> This is a Boolean type Input. Default Value is FALSE. If you set it to TRUE then it allows user to format any cell on a protected worksheet.<\/li>\n<li><strong>AllowFormattingColumns: (Optional)<\/strong> This is a Boolean type Input. Default Value is FALSE. If you set it to TRUE then it allows user to format any Column on a protected worksheet.<\/li>\n<li><strong>AllowFormattingRows: (Optional)<\/strong> This is a Boolean type Input. Default Value is FALSE. If you set it to TRUE then it allows user to format any Row of the protected worksheet.<\/li>\n<li><strong>AllowInsertingColumns: (Optional)<\/strong> This is a Boolean type Input. Default Value is FALSE. If you set it to TRUE then it allows user to insert column in the protected worksheet.<\/li>\n<li><strong>AllowInsertingRows: (Optional)<\/strong> This is a Boolean type Input. Default Value is FALSE. If you set it to TRUE then it allows user to insert Rows in the protected worksheet.<\/li>\n<li><strong>AllowInsertingHyperlinks: (Optional)<\/strong> This is a Boolean type Input. Default Value is FALSE. If you set it to TRUE then it allows user to insert Hyperlinks on the protected worksheet.<\/li>\n<li><strong>AllowDeletingColumns: (Optional)<\/strong> This is a Boolean type Input. Default Value is FALSE. If you set it to TRUE then it allows user to delete columns from the protected worksheet.<\/li>\n<li><strong>AllowDeletingRows: (Optional)<\/strong> This is a Boolean type Input. Default Value is FALSE. If you set it to TRUE then it allows user to delete rows from the protected worksheet.<\/li>\n<li><strong>AllowSorting: (Optional)<\/strong> This is a Boolean type Input. Default Value is FALSE. If you set it to TRUE then it allows user to sort data in the protected worksheet. <strong>Note:<\/strong>To apply sort every cell in the range must be unlocked.<\/li>\n<li><strong>AllowFiltering: (Optional)<\/strong> This is a Boolean type Input. Default Value is FALSE. This will allow user to change the filter criteria but can not enable or disable the AUTO-FILTER option in worksheet. Users are allowed just to change the different filters on an already existing auto-filter.<\/li>\n<li><strong>AllowUsingPivotTables: (Optional)<\/strong> This is a Boolean type Input. Default Value is FALSE. If you set it to TRUE then it allows the user to use pivot table reports on the protected worksheet.<\/li>\n<\/ul>\n<\/td>\n<\/tr>\n<\/table>\n<\/div>\n<h2>Example 1: Protect your Sheet with All Default options<\/h2>\n<pre><code class=\"language-vbnet\">\nFunction ProtectSheet_Default()\n'To protect the Sheet1 without any password with all default parameters\n    Worksheets(\"Sheet1\").Protect\nEnd Function\n<\/code><\/pre>\n<h2>Example 2: Protect your Sheet with a password<\/h2>\n<pre><code class=\"language-vbnet\">\nFunction ProtectSheet_Password()\n'To protect the Sheet1 with a password and with all other default parameters\n'Passwords are case sensitive. Hence Vishwa123 is not equal to visHwa123\n    Worksheets(\"Sheet1\").Protect Password:=\"Vishwa123\"\nEnd Function\n<\/code><\/pre>\n<h2>Example 3: Protect your Sheet with all parameters passed in it<\/h2>\n<pre><code class=\"language-vbnet\">\nFunction ProtectSheet_All_Parameters_passed()\n'Protect Method with all the parameters passed in it\n    Worksheets(\"Sheet1\").Protect _\n        Password:=\"Vishwa123\", _\n        DrawingObjects:=False, _\n        Contents:=True, _\n        Scenarios:=True, _\n        UserInterfaceOnly:=True, _\n        AllowFormattingCells:=True, _\n        AllowFormattingColumns:=True, _\n        AllowFormattingRows:=True, _\n        AllowInsertingColumns:=True, _\n        AllowInsertingRows:=True, _\n        AllowInsertingHyperlinks:=True, _\n        AllowDeletingColumns:=True, _\n        AllowDeletingRows:=True, _\n        AllowSorting:=False, _\n        AllowFiltering:=False, _\n        AllowUsingPivotTables:=False\nEnd Function\n<\/code><\/pre>\n<h1>Excel Macro to UnProtect your Protected Sheet<\/h1>\n<p>To Unprotect your already protected sheet, you need to use <strong>WorkSheet.unprotect<\/strong> method. To Unprotect a Sheet all you need to pass is the password. No other parameter required to unprotect a sheet. Password is NOT required in all case. You need to pass a correct password only when your Sheet is protected by a giving a password. It is not protected by not providing any password then no need to pass the password as well.<\/p>\n<h2>Syntax:<\/h2>\n<p><i>WorkSheet.Unprotect (password)<\/i><\/p>\n<h3>Where:<\/h3>\n<p><strong>Password (Optional) :<\/strong> is the password by which your Sheet is protected. If your Sheet is not protected by any password then this parameter can be omitted.<\/p>\n<h2>Example 1:  To Unprotect a WorkSheet protected by a Passwrord<\/h2>\n<pre><code class=\"language-vbnet\">\nFunction UnProtectSheet()\n'UnProtect Method with a password passed\n    Worksheets(\"Sheet1\").Unprotect (\"Vishwa123\")\nEnd Function\n<\/code><\/pre>\n<h2>Example 2:  To Unprotect a WorkSheet which is not protected by a Password<\/h2>\n<pre><code class=\"language-vbnet\">\nFunction UnProtectSheet()\n'UnProtect Method without a password passed\n    Worksheets(\"Sheet1\").Unprotect\nEnd Function\n<\/code><\/pre>\n<h2>Special Cases:<\/h2>\n<p>I just thought of putting a simple note on all those scenarios which are possible while unprotecting a Sheet.<\/p>\n<h3>Case 1:  What if I passed a Wrong Password <\/h3>\n<p>In this case if you will get a <strong>1004 : Run Time Error <\/strong>. If you capture the Error using <strong>On Error GoTo..<\/strong> statement like shown in below code, you will receive the error message like shown in below message box:<\/p>\n<pre><code class=\"language-vbnet\">\nFunction UnProtectSheet()\n'UnProtect Method with a password passed\nOn Error GoTo err\n    Worksheets(\"Sheet1\").Unprotect (\"vishwa123\")\nerr:\n    MsgBox err.Number &amp; \" :  \" &amp; err.Description\nEnd Function\n<\/code><\/pre>\n<p><img decoding=\"async\" src=\"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2014\/06\/Error-Message.png\" alt=\"Unprotect-Sheet - Error-Message\" title=\"Unprotect-Sheet - Error-Message\" width=\"496\" height=\"169\" class=\"aligncenter size-full wp-image-4057\" \/><\/p>\n<h3>Case 2:  What if I passed a random Password for a sheet which is protected by NO password <\/h3>\n<p>In such case this method will unprotect sheet without throwing any error message.<\/p>\n<h3>Case 3:  What if I DO NOT pass any password for a Protected sheet which is protected by a Password<\/h3>\n<p>In such case this method will popup a excel built-in input box to enter the password to unprotect the Sheet.<br \/>\n  <strong>i)<\/strong> On passing a valid password sheet will be unprotected.<br \/>\n <strong>ii)<\/strong> In case of wrong password entered in the input box, same error message will be thrown as shown in the above picture.<br \/>\n<strong>iii)<\/strong> If you cancel the input box then Sheet will not be unprotected without any Error Message.<\/p>\n<div class=\"alert alert-success\">\n<h3>Now you know&#8230;<\/h3>\n<hr \/>\n<p>Now you know to use .Protect and .Unprotect method to protect and unprotect a WorkSheet using Excel VBA\n<\/p><\/div>\n<p><a name=\"protect-unprotect-excel-sheet\"><\/a><\/p>\n<h1>How to Protect your Sheet using Excel Built-In function<\/h1>\n<p>Follow the below simple steps to Protect your Sheet<br \/>\n<strong>Step 1: <\/strong> Activate your Sheet and go to <strong>Review Tab<\/strong> of the Excel Ribbon<br \/>\n<strong>Step 2: <\/strong> Now Click on Protect Sheet option shown in the below Picture:<br \/>\n<img decoding=\"async\" src=\"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2014\/06\/Protect-Worksheet.png\" alt=\"Protect-Worksheet\" title=\"Protect-Worksheet\" width=\"521\" height=\"119\" class=\"aligncenter size-full wp-image-4035\" \/><br \/>\n<strong>Step 3: <\/strong> Now a Popup Window will appear looking for Password.<\/p>\n<h3>Note:<\/h3>\n<p><strong>1.<\/strong> Giving a valid password is not mandatory. You leave it blank and press OK. In that case there will be no Popup for confirmation of your entered password as shown in the Step No: 4.<br \/>\n<strong>2.<\/strong> <i>There are so many different options available there but for now I am not going to cover them. Keep looking this space for a detailed article on the same.<\/i><br \/>\n&nbsp;<br \/>\n<img decoding=\"async\" src=\"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2014\/06\/Protect-Sheet-Password.png\" alt=\"Protect-Sheet-Password\" title=\"Protect Sheet - Password\" width=\"271\" height=\"314\" class=\"aligncenter size-full wp-image-4037\" \/><br \/>\n<strong>Step 4: <\/strong> Re-Enter the same password <i>(This popup will appear only if you have passed a password in the previous step)<\/i><br \/>\n<img decoding=\"async\" src=\"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2014\/06\/Protect-Sheet-Confimr-Password.png\" alt=\"Protect-Sheet-Confirm-Password\" title=\"Protect-Sheet-Confirm-Password\" width=\"305\" height=\"185\" class=\"aligncenter size-full wp-image-4038\" \/><\/p>\n<h3>Now you are done with Protecting your Worksheet. To confirm the same, double click on any of the cell in the Worksheet, you will get following error message:<\/h3>\n<p>&nbsp;<br \/>\n<img decoding=\"async\" src=\"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2014\/06\/Protected-Sheet-Error-Message.png\" alt=\"Protected-Sheet-Error-Message\" title=\"Protected-Sheet-Error-Message\" width=\"889\" height=\"127\" class=\"aligncenter size-full wp-image-4040\" \/><\/p>\n<h1>How to Un-Protect your Protected WorkSheet using Excel Built-In function<\/h1>\n<p>As soon as you protected your WorkSheet by following the above Steps, you will see that <strong>Protect Sheet<\/strong> option is changed to <strong>UnProtect Sheet<\/strong> option as shown in the below picture:<br \/>\n&nbsp;<br \/>\n<img decoding=\"async\" src=\"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2014\/06\/Unprotect-Worksheet.png\" alt=\"Unprotect - Worksheet\" title=\"Unprotect - Worksheet\" width=\"537\" height=\"119\" class=\"aligncenter size-full wp-image-4041\" \/><br \/>\n&nbsp;<br \/>\n<strong>Step 1.<\/strong> Click on Unprotect sheet button in your WorkSheet<br \/>\n<strong>Step 2.<\/strong> A popup will will appear asking for Password to Unlock the sheet<\/p>\n<h3>Note:<\/h3>\n<p><i>This popup will appear ONLY when your Sheet was protected by passing a Password. If any password is not passed while protecting the WorkSheet, this popup will not appear and your sheet will be automatically unprotected.<\/i><br \/>\n&nbsp;<br \/>\n<img decoding=\"async\" src=\"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2014\/06\/Unprotect-Sheet-password.png\" alt=\"Unprotect-Sheet-password\" title=\"Unprotect-Sheet-password\" width=\"279\" height=\"106\" class=\"aligncenter size-full wp-image-4042\" \/>[\/et_pb_text][et_pb_blurb title=&#8221;You may like these article too&#8221; use_icon=&#8221;on&#8221; font_icon=&#8221;&#x4e;||divi||400&#8243; _builder_version=&#8221;4.17.6&#8243; _module_preset=&#8221;0249c68e-4de8-4f44-84ff-a9b1850785b6&#8243; hover_enabled=&#8221;0&#8243; global_colors_info=&#8221;{}&#8221; sticky_enabled=&#8221;0&#8243;]<\/p>\n<ol>\n<li> <a href=\"https:\/\/vmlogger.com\/excel\/2018\/06\/40-useful-excel-macro-examples-for-beginners-part-2-of-2\/\" target=\"_blank\" rel=\"noopener\">40 Useful Excel Macro [VBA] examples &#8211; Part 2 of 2<\/a><\/li>\n<li> <a href=\"https:\/\/vmlogger.com\/excel\/2018\/06\/40-useful-excel-macro-examples-for-beginners-part-1-of-2\/\" target=\"_blank\" rel=\"noopener\">40 Useful Excel Macro [VBA] examples &#8211; Part 1 of 2<\/a><\/li>\n<li> <a href=\"https:\/\/vmlogger.com\/excel\/2012\/01\/difference-between-sheets-and-worksheets-in-excel-macro\/\" target=\"_blank\" rel=\"noopener\">Difference between Sheets and Worksheets in Excel Macro<\/a><\/li>\n<li> <a href=\"https:\/\/vmlogger.com\/excel\/2014\/06\/excel-cell-masking-for-password\/\" target=\"_blank\" rel=\"noopener\">Excel Tip : How to Make an Excel Cell secured for Password<\/a><\/li>\n<li> <a href=\"https:\/\/vmlogger.com\/excel\/2017\/10\/vba-to-open-a-password-protected-workbook\/\" target=\"_blank\" rel=\"noopener\">VBA to Open or Create a Password Protected Workbook<\/a><\/li>\n<li> <a href=\"https:\/\/vmlogger.com\/excel\/2014\/05\/protect-excel-sheet\/\" target=\"_blank\" rel=\"noopener\">Excel Trick &#8211; Sheet Protection &#8211; Protect it and Stay Free<\/a><\/li>\n<\/ol>\n<p>[\/et_pb_blurb][\/et_pb_column][\/et_pb_row][\/et_pb_section]<\/p>\n<span class=\"et_bloom_bottom_trigger\"><\/span>","protected":false},"excerpt":{"rendered":"<p>This is a small VBA code to help you in dealing with Protecting and UnProtecting the WorkSheet using Excel Macro. Assuming the fact here that you know How to Protect or UnProtect a Sheet using Excel In-Built function . For those who do not know protect or unprotect the sheet using Excel inbuilt function, I [&hellip;]<\/p>\n","protected":false},"author":45,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_et_pb_use_builder":"on","_et_pb_old_content":"","_et_gb_content_width":"","footnotes":""},"categories":[1673,1246,1674,1678],"tags":[],"class_list":["post-4032","post","type-post","status-publish","format-standard","hentry","category-excel-functions","category-macro","category-excel-macro-basics","category-interesting-vba-functions"],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v23.5 (Yoast SEO v23.5) - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Excel Macro : Excel VBA code to Protect OR UnProtect Sheet - Let&#039;s excel in Excel<\/title>\n<meta name=\"description\" content=\"Excel VBA to protect a worksheet. Excel VBA to unprotect a protected worksheet. Protect or unprotect a using the Excel Built-in feature.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/vmlogger.com\/excel\/2024\/02\/protect-unprotect-sheet-using-vba\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Excel Macro : Excel VBA code to Protect OR UnProtect Sheet\" \/>\n<meta property=\"og:description\" content=\"Excel VBA to protect a worksheet. Excel VBA to unprotect a protected worksheet. Protect or unprotect a using the Excel Built-in feature.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/vmlogger.com\/excel\/2024\/02\/protect-unprotect-sheet-using-vba\/\" \/>\n<meta property=\"og:site_name\" content=\"Let&#039;s excel in Excel\" \/>\n<meta property=\"article:publisher\" content=\"http:\/\/www.facebook.com\/vmlogger\" \/>\n<meta property=\"article:author\" content=\"http:\/\/www.facebook.com\/vmlogger\" \/>\n<meta property=\"article:published_time\" content=\"2024-02-03T06:55:30+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2014\/06\/Error-Message.png\" \/>\n<meta name=\"author\" content=\"Vishwamitra Mishra\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@https:\/\/www.twitter.com\/learnexcelmacro\" \/>\n<meta name=\"twitter:site\" content=\"@learnexcelmacro\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Vishwamitra Mishra\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"8 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/vmlogger.com\/excel\/2024\/02\/protect-unprotect-sheet-using-vba\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/vmlogger.com\/excel\/2024\/02\/protect-unprotect-sheet-using-vba\/\"},\"author\":{\"name\":\"Vishwamitra Mishra\",\"@id\":\"https:\/\/vmlogger.com\/excel\/#\/schema\/person\/7500a107b0b2d35a8492acf0d11fc8e5\"},\"headline\":\"Excel Macro : Excel VBA code to Protect OR UnProtect Sheet\",\"datePublished\":\"2024-02-03T06:55:30+00:00\",\"dateModified\":\"2024-02-03T06:55:30+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/vmlogger.com\/excel\/2024\/02\/protect-unprotect-sheet-using-vba\/\"},\"wordCount\":1498,\"commentCount\":6,\"publisher\":{\"@id\":\"https:\/\/vmlogger.com\/excel\/#\/schema\/person\/7500a107b0b2d35a8492acf0d11fc8e5\"},\"image\":{\"@id\":\"https:\/\/vmlogger.com\/excel\/2024\/02\/protect-unprotect-sheet-using-vba\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2014\/06\/Error-Message.png\",\"articleSection\":[\"Excel Functions\",\"Excel Macro\",\"Excel Macro Basics\",\"Interesting VBA Functions\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/vmlogger.com\/excel\/2024\/02\/protect-unprotect-sheet-using-vba\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/vmlogger.com\/excel\/2024\/02\/protect-unprotect-sheet-using-vba\/\",\"url\":\"https:\/\/vmlogger.com\/excel\/2024\/02\/protect-unprotect-sheet-using-vba\/\",\"name\":\"Excel Macro : Excel VBA code to Protect OR UnProtect Sheet - Let&#039;s excel in Excel\",\"isPartOf\":{\"@id\":\"https:\/\/vmlogger.com\/excel\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/vmlogger.com\/excel\/2024\/02\/protect-unprotect-sheet-using-vba\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/vmlogger.com\/excel\/2024\/02\/protect-unprotect-sheet-using-vba\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2014\/06\/Error-Message.png\",\"datePublished\":\"2024-02-03T06:55:30+00:00\",\"dateModified\":\"2024-02-03T06:55:30+00:00\",\"description\":\"Excel VBA to protect a worksheet. Excel VBA to unprotect a protected worksheet. Protect or unprotect a using the Excel Built-in feature.\",\"breadcrumb\":{\"@id\":\"https:\/\/vmlogger.com\/excel\/2024\/02\/protect-unprotect-sheet-using-vba\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/vmlogger.com\/excel\/2024\/02\/protect-unprotect-sheet-using-vba\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/vmlogger.com\/excel\/2024\/02\/protect-unprotect-sheet-using-vba\/#primaryimage\",\"url\":\"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2014\/06\/Error-Message.png\",\"contentUrl\":\"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2014\/06\/Error-Message.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/vmlogger.com\/excel\/2024\/02\/protect-unprotect-sheet-using-vba\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/vmlogger.com\/excel\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Excel Functions\",\"item\":\"https:\/\/vmlogger.com\/excel\/excel-functions\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"Excel Macro : Excel VBA code to Protect OR UnProtect Sheet\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/vmlogger.com\/excel\/#website\",\"url\":\"https:\/\/vmlogger.com\/excel\/\",\"name\":\"Let&#039;s excel in Excel\",\"description\":\"Let&#039;s share knowledge\",\"publisher\":{\"@id\":\"https:\/\/vmlogger.com\/excel\/#\/schema\/person\/7500a107b0b2d35a8492acf0d11fc8e5\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/vmlogger.com\/excel\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":[\"Person\",\"Organization\"],\"@id\":\"https:\/\/vmlogger.com\/excel\/#\/schema\/person\/7500a107b0b2d35a8492acf0d11fc8e5\",\"name\":\"Vishwamitra Mishra\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/vmlogger.com\/excel\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2022\/07\/avataaars-1.png\",\"contentUrl\":\"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2022\/07\/avataaars-1.png\",\"width\":528,\"height\":560,\"caption\":\"Vishwamitra Mishra\"},\"logo\":{\"@id\":\"https:\/\/vmlogger.com\/excel\/#\/schema\/person\/image\/\"},\"description\":\"My name is Vishwamitra Mishra. Friends Call me Vishwa. I hold a Bachelor\u2019s Degree in Computer Science from D.A.V.V. Indore &amp; currently working as a Technical Lead having over 7 years of experience.\",\"sameAs\":[\"http:\/\/www.learnexcelmacro.com\",\"http:\/\/www.facebook.com\/vmlogger\",\"https:\/\/x.com\/https:\/\/www.twitter.com\/learnexcelmacro\",\"https:\/\/www.youtube.com\/c\/VMLogger\"],\"url\":\"https:\/\/vmlogger.com\/excel\/author\/vishwamitra\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Excel Macro : Excel VBA code to Protect OR UnProtect Sheet - Let&#039;s excel in Excel","description":"Excel VBA to protect a worksheet. Excel VBA to unprotect a protected worksheet. Protect or unprotect a using the Excel Built-in feature.","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:\/\/vmlogger.com\/excel\/2024\/02\/protect-unprotect-sheet-using-vba\/","og_locale":"en_US","og_type":"article","og_title":"Excel Macro : Excel VBA code to Protect OR UnProtect Sheet","og_description":"Excel VBA to protect a worksheet. Excel VBA to unprotect a protected worksheet. Protect or unprotect a using the Excel Built-in feature.","og_url":"https:\/\/vmlogger.com\/excel\/2024\/02\/protect-unprotect-sheet-using-vba\/","og_site_name":"Let&#039;s excel in Excel","article_publisher":"http:\/\/www.facebook.com\/vmlogger","article_author":"http:\/\/www.facebook.com\/vmlogger","article_published_time":"2024-02-03T06:55:30+00:00","og_image":[{"url":"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2014\/06\/Error-Message.png"}],"author":"Vishwamitra Mishra","twitter_card":"summary_large_image","twitter_creator":"@https:\/\/www.twitter.com\/learnexcelmacro","twitter_site":"@learnexcelmacro","twitter_misc":{"Written by":"Vishwamitra Mishra","Est. reading time":"8 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/vmlogger.com\/excel\/2024\/02\/protect-unprotect-sheet-using-vba\/#article","isPartOf":{"@id":"https:\/\/vmlogger.com\/excel\/2024\/02\/protect-unprotect-sheet-using-vba\/"},"author":{"name":"Vishwamitra Mishra","@id":"https:\/\/vmlogger.com\/excel\/#\/schema\/person\/7500a107b0b2d35a8492acf0d11fc8e5"},"headline":"Excel Macro : Excel VBA code to Protect OR UnProtect Sheet","datePublished":"2024-02-03T06:55:30+00:00","dateModified":"2024-02-03T06:55:30+00:00","mainEntityOfPage":{"@id":"https:\/\/vmlogger.com\/excel\/2024\/02\/protect-unprotect-sheet-using-vba\/"},"wordCount":1498,"commentCount":6,"publisher":{"@id":"https:\/\/vmlogger.com\/excel\/#\/schema\/person\/7500a107b0b2d35a8492acf0d11fc8e5"},"image":{"@id":"https:\/\/vmlogger.com\/excel\/2024\/02\/protect-unprotect-sheet-using-vba\/#primaryimage"},"thumbnailUrl":"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2014\/06\/Error-Message.png","articleSection":["Excel Functions","Excel Macro","Excel Macro Basics","Interesting VBA Functions"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/vmlogger.com\/excel\/2024\/02\/protect-unprotect-sheet-using-vba\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/vmlogger.com\/excel\/2024\/02\/protect-unprotect-sheet-using-vba\/","url":"https:\/\/vmlogger.com\/excel\/2024\/02\/protect-unprotect-sheet-using-vba\/","name":"Excel Macro : Excel VBA code to Protect OR UnProtect Sheet - Let&#039;s excel in Excel","isPartOf":{"@id":"https:\/\/vmlogger.com\/excel\/#website"},"primaryImageOfPage":{"@id":"https:\/\/vmlogger.com\/excel\/2024\/02\/protect-unprotect-sheet-using-vba\/#primaryimage"},"image":{"@id":"https:\/\/vmlogger.com\/excel\/2024\/02\/protect-unprotect-sheet-using-vba\/#primaryimage"},"thumbnailUrl":"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2014\/06\/Error-Message.png","datePublished":"2024-02-03T06:55:30+00:00","dateModified":"2024-02-03T06:55:30+00:00","description":"Excel VBA to protect a worksheet. Excel VBA to unprotect a protected worksheet. Protect or unprotect a using the Excel Built-in feature.","breadcrumb":{"@id":"https:\/\/vmlogger.com\/excel\/2024\/02\/protect-unprotect-sheet-using-vba\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/vmlogger.com\/excel\/2024\/02\/protect-unprotect-sheet-using-vba\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/vmlogger.com\/excel\/2024\/02\/protect-unprotect-sheet-using-vba\/#primaryimage","url":"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2014\/06\/Error-Message.png","contentUrl":"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2014\/06\/Error-Message.png"},{"@type":"BreadcrumbList","@id":"https:\/\/vmlogger.com\/excel\/2024\/02\/protect-unprotect-sheet-using-vba\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/vmlogger.com\/excel\/"},{"@type":"ListItem","position":2,"name":"Excel Functions","item":"https:\/\/vmlogger.com\/excel\/excel-functions\/"},{"@type":"ListItem","position":3,"name":"Excel Macro : Excel VBA code to Protect OR UnProtect Sheet"}]},{"@type":"WebSite","@id":"https:\/\/vmlogger.com\/excel\/#website","url":"https:\/\/vmlogger.com\/excel\/","name":"Let&#039;s excel in Excel","description":"Let&#039;s share knowledge","publisher":{"@id":"https:\/\/vmlogger.com\/excel\/#\/schema\/person\/7500a107b0b2d35a8492acf0d11fc8e5"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/vmlogger.com\/excel\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":["Person","Organization"],"@id":"https:\/\/vmlogger.com\/excel\/#\/schema\/person\/7500a107b0b2d35a8492acf0d11fc8e5","name":"Vishwamitra Mishra","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/vmlogger.com\/excel\/#\/schema\/person\/image\/","url":"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2022\/07\/avataaars-1.png","contentUrl":"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2022\/07\/avataaars-1.png","width":528,"height":560,"caption":"Vishwamitra Mishra"},"logo":{"@id":"https:\/\/vmlogger.com\/excel\/#\/schema\/person\/image\/"},"description":"My name is Vishwamitra Mishra. Friends Call me Vishwa. I hold a Bachelor\u2019s Degree in Computer Science from D.A.V.V. Indore &amp; currently working as a Technical Lead having over 7 years of experience.","sameAs":["http:\/\/www.learnexcelmacro.com","http:\/\/www.facebook.com\/vmlogger","https:\/\/x.com\/https:\/\/www.twitter.com\/learnexcelmacro","https:\/\/www.youtube.com\/c\/VMLogger"],"url":"https:\/\/vmlogger.com\/excel\/author\/vishwamitra\/"}]}},"_links":{"self":[{"href":"https:\/\/vmlogger.com\/excel\/wp-json\/wp\/v2\/posts\/4032"}],"collection":[{"href":"https:\/\/vmlogger.com\/excel\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/vmlogger.com\/excel\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/vmlogger.com\/excel\/wp-json\/wp\/v2\/users\/45"}],"replies":[{"embeddable":true,"href":"https:\/\/vmlogger.com\/excel\/wp-json\/wp\/v2\/comments?post=4032"}],"version-history":[{"count":0,"href":"https:\/\/vmlogger.com\/excel\/wp-json\/wp\/v2\/posts\/4032\/revisions"}],"wp:attachment":[{"href":"https:\/\/vmlogger.com\/excel\/wp-json\/wp\/v2\/media?parent=4032"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/vmlogger.com\/excel\/wp-json\/wp\/v2\/categories?post=4032"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/vmlogger.com\/excel\/wp-json\/wp\/v2\/tags?post=4032"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}