{"id":131,"date":"2022-09-14T11:54:19","date_gmt":"2022-09-14T11:54:19","guid":{"rendered":"https:\/\/www.excelfinancemastery.com\/?p=30"},"modified":"2024-01-26T23:23:18","modified_gmt":"2024-01-26T23:23:18","slug":"set-read-only-recommended-in-excel","status":"publish","type":"post","link":"https:\/\/www.tiposaurus.co.uk\/set-read-only-recommended-in-excel\/","title":{"rendered":"Set Read Only Recommended in Excel"},"content":{"rendered":"<p>In this guide, we&#8217;ll explain how to set read only recommended in Excel. That means that whenever someone opens it, Excel will suggest they open it as read only.<\/p>\n<p>While setting read only recommended can prevent accidental modifications, users can still choose not to open as read only, so we&#8217;ll also cover adding passwords to modify your spreadsheet, as well adding a passwords to open it at all.<\/p>\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_62 counter-hierarchy ez-toc-counter ez-toc-grey ez-toc-container-direction\">\n<div class=\"ez-toc-title-container\">\n<p class=\"ez-toc-title \" >Table of Contents<\/p>\n<span class=\"ez-toc-title-toggle\"><a href=\"#\" class=\"ez-toc-pull-right ez-toc-btn ez-toc-btn-xs ez-toc-btn-default ez-toc-toggle\" aria-label=\"Toggle Table of Content\"><span class=\"ez-toc-js-icon-con\"><span class=\"\"><span class=\"eztoc-hide\" style=\"display:none;\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><svg style=\"fill: #999;color:#999\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" class=\"list-377408\" width=\"20px\" height=\"20px\" viewBox=\"0 0 24 24\" fill=\"none\"><path d=\"M6 6H4v2h2V6zm14 0H8v2h12V6zM4 11h2v2H4v-2zm16 0H8v2h12v-2zM4 16h2v2H4v-2zm16 0H8v2h12v-2z\" fill=\"currentColor\"><\/path><\/svg><svg style=\"fill: #999;color:#999\" class=\"arrow-unsorted-368013\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"10px\" height=\"10px\" viewBox=\"0 0 24 24\" version=\"1.2\" baseProfile=\"tiny\"><path d=\"M18.2 9.3l-6.2-6.3-6.2 6.3c-.2.2-.3.4-.3.7s.1.5.3.7c.2.2.4.3.7.3h11c.3 0 .5-.1.7-.3.2-.2.3-.5.3-.7s-.1-.5-.3-.7zM5.8 14.7l6.2 6.3 6.2-6.3c.2-.2.3-.5.3-.7s-.1-.5-.3-.7c-.2-.2-.4-.3-.7-.3h-11c-.3 0-.5.1-.7.3-.2.2-.3.5-.3.7s.1.5.3.7z\"\/><\/svg><\/span><\/span><\/span><\/a><\/span><\/div>\n<nav><ul class='ez-toc-list ez-toc-list-level-1 ' ><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/www.tiposaurus.co.uk\/set-read-only-recommended-in-excel\/#Why_set_read_only_recommended\" title=\"Why set read only recommended?\">Why set read only recommended?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/www.tiposaurus.co.uk\/set-read-only-recommended-in-excel\/#Limitations_of_read_only_recommended\" title=\"Limitations of read only recommended\">Limitations of read only recommended<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/www.tiposaurus.co.uk\/set-read-only-recommended-in-excel\/#Set_read_only_recommended_in_Excel_365\" title=\"Set read only recommended in Excel 365\">Set read only recommended in Excel 365<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/www.tiposaurus.co.uk\/set-read-only-recommended-in-excel\/#Set_read_only_recommended\" title=\"Set read only recommended\">Set read only recommended<\/a><ul class='ez-toc-list-level-3' ><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/www.tiposaurus.co.uk\/set-read-only-recommended-in-excel\/#Set_read_only_recommended_using_VBA\" title=\"Set read only recommended using VBA\">Set read only recommended using VBA<\/a><\/li><\/ul><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/www.tiposaurus.co.uk\/set-read-only-recommended-in-excel\/#Set_a_password_to_modify_an_Excel_spreadsheet\" title=\"Set a password to modify an Excel spreadsheet\">Set a password to modify an Excel spreadsheet<\/a><ul class='ez-toc-list-level-3' ><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-7\" href=\"https:\/\/www.tiposaurus.co.uk\/set-read-only-recommended-in-excel\/#Set_a_password_to_modify_a_spreadsheet_using_VBA\" title=\"Set a password to modify a spreadsheet using VBA\">Set a password to modify a spreadsheet using VBA<\/a><\/li><\/ul><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-8\" href=\"https:\/\/www.tiposaurus.co.uk\/set-read-only-recommended-in-excel\/#Set_a_password_to_open_an_Excel_spreadsheet\" title=\"Set a password to open an Excel spreadsheet\">Set a password to open an Excel spreadsheet<\/a><ul class='ez-toc-list-level-3' ><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-9\" href=\"https:\/\/www.tiposaurus.co.uk\/set-read-only-recommended-in-excel\/#Set_password_to_open_in_Excel_365\" title=\"Set password to open in Excel 365\">Set password to open in Excel 365<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-10\" href=\"https:\/\/www.tiposaurus.co.uk\/set-read-only-recommended-in-excel\/#Set_password_to_open_in_earlier_versions_of_Excel\" title=\"Set password to open in earlier versions of Excel\">Set password to open in earlier versions of Excel<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-11\" href=\"https:\/\/www.tiposaurus.co.uk\/set-read-only-recommended-in-excel\/#Set_a_password_to_open_a_spreadsheet_using_VBA\" title=\"Set a password to open a spreadsheet using VBA\">Set a password to open a spreadsheet using VBA<\/a><\/li><\/ul><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-12\" href=\"https:\/\/www.tiposaurus.co.uk\/set-read-only-recommended-in-excel\/#Remove_read_only_recommended_or_password_from_an_Excel_spreadsheet\" title=\"Remove read only recommended or password from an Excel spreadsheet\">Remove read only recommended or password from an Excel spreadsheet<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-13\" href=\"https:\/\/www.tiposaurus.co.uk\/set-read-only-recommended-in-excel\/#Wrap_up\" title=\"Wrap up\">Wrap up<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-14\" href=\"https:\/\/www.tiposaurus.co.uk\/set-read-only-recommended-in-excel\/#References\" title=\"References\">References<\/a><\/li><\/ul><\/nav><\/div>\n<h2><span class=\"ez-toc-section\" id=\"Why_set_read_only_recommended\"><\/span>Why set read only recommended?<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Before we go into the detail, we&#8217;ll first give a couple of examples where setting a spreadsheet to be read only is very useful:<\/p>\n<ul>\n<li>Prevent unintended changes &#8211; perhaps you work with other people who will be using your spreadsheet. In some cases, they (or even you) might need to open it but just to use some values. If so, setting read only recommended is good practice\u00a0 &#8211; it will prevent someone from accidentally making changes and saving them, assuming they choose to accept and actually do open as read only.<\/li>\n<li>Avoid locking the file &#8211; we&#8217;ve all experienced it: you work on a spreadsheet with a few others in your team, a deadline looms and you need to make a quick update to this file, but &#8211; oh no &#8211; it&#8217;s locked for editing by someone else &#8211; who could it be? Now you&#8217;re using your precious time to find who is in the file, rather than just updating it. You can help to avoid this by turning on read only recommended for the workbook, then only those who need to edit the file will go in to edit it.<\/li>\n<\/ul>\n<h2><span class=\"ez-toc-section\" id=\"Limitations_of_read_only_recommended\"><\/span>Limitations of read only recommended<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>It&#8217;s always good to know potential issues or downsides with what you&#8217;re doing so we&#8217;ll now explore some of the limitations of the &#8216;read only recommended&#8217; option in Excel. Some of the key ones are:<\/p>\n<ul>\n<li>It can be ignored &#8211; The prompt will ask the user if they want to open the spreadsheet as read only &#8211; clicking &#8216;Yes&#8217; to open as read only, or &#8216;No&#8217; to open normally. However, anyone can just click &#8216;No&#8217; if they like.<\/li>\n<li>Doesn&#8217;t prevent access &#8211; Another limitation is it doesn&#8217;t prevent anyone from accessing your file. Anyone can still open it as they would, without a password..<\/li>\n<li>Can be turned off by the user &#8211; Another one worth calling out is that anyone can turn off the read only recommended by re-saving the file without it selected.\u00a0 We&#8217;ve even included some instructions on <a href=\"#remove-read-only\">how to turn off read only recommended<\/a> below,<span style=\"color: #ff9900;\"><span style=\"color: #000000;\">\u00a0for benevolent users only.<\/span><\/span><\/li>\n<\/ul>\n<h2><span class=\"ez-toc-section\" id=\"Set_read_only_recommended_in_Excel_365\"><\/span>Set read only recommended in Excel 365<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>The simplest way to do this in more recent versions of Excel is via the &#8220;File&#8221; tab in the ribbon:<\/p>\n<ol>\n<li>Select &#8220;File&#8221; from the ribbon then choose &#8220;Info&#8221;.<\/li>\n<li>In the information screen, choose &#8220;Protect Workbook&#8221; &gt; &#8220;Always Open Read Only&#8221;.<\/li>\n<\/ol>\n<p>These two steps are shown in the screenshot below.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-35 size-large\" src=\"https:\/\/www.excelfinancemastery.com\/wp-content\/uploads\/2022\/09\/readonly_1_info-1024x453.png\" alt=\"\" width=\"1024\" height=\"453\" \/><\/p>\n<p>The next time you save and re-open the workbook it will ask whether you want to open read only.<\/p>\n<h2><span class=\"ez-toc-section\" id=\"Set_read_only_recommended\"><\/span>Set read only recommended<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>If the above instructions didn&#8217;t work (perhaps you have a different version of Excel), then try the following steps to set read only recommended while saving a file.<\/p>\n<ul>\n<li>Choose File &gt; Save As from the ribbon .\u00a0 Do this even if you don&#8217;t want to save the workbook with a different filename. Click &#8216;Browse&#8217; on the list of locations to get the &#8220;Save As&#8221; box up, and browse to the location where you want to save the workbook. Alternatively you can press the &#8220;Save As&#8221; shortcut key: F12 on the keyboard.<\/li>\n<li>Enter a filename. If you don&#8217;t want to change the name of the spreadsheet then just leave this the same as the current name.<\/li>\n<li>Next to the save button, click (1) &#8220;Tools&#8221; then (2) &#8220;General Options&#8221;.<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-large wp-image-36\" src=\"https:\/\/www.excelfinancemastery.com\/wp-content\/uploads\/2022\/09\/readonly_2_saveas-1024x823.png\" alt=\"\" width=\"1024\" height=\"823\" \/><\/p>\n<ul>\n<li>Another box will open up which has a checkbox for &#8220;read only recommended&#8221; &#8211; make sure that this is selected and click &#8216;OK&#8217;.<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-37\" src=\"https:\/\/www.excelfinancemastery.com\/wp-content\/uploads\/2022\/09\/readonly_3_readonly.png\" alt=\"\" width=\"524\" height=\"398\" \/><\/p>\n<ul>\n<li>Finally save and close the file.<\/li>\n<\/ul>\n<p>The next time you open this file, Excel will ask you whether you want to open it as read only.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Set_read_only_recommended_using_VBA\"><\/span>Set read only recommended using VBA<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>If you&#8217;re developing a macro which saves a spreadsheet, you might also want to set it as read only recommended to prevent users making accidental changes to it (and all the other reasons above).<\/p>\n<p>Tp do this, include the parameter <code>ReadOnlyRecommended := True<\/code> when calling the <code>Workbook.SaveAs<\/code> routine. For example, the following code will save the current workbook as a macro enabled file called &#8220;MyFile.xlsm&#8221; which is read-only recommended.<\/p>\n<pre>Sub SaveWorkbook()\n  ThisWorkbook.SaveAs Filename:=\"MyFile.xlsm\", FileFormat:=xlOpenXMLWorkbookMacroEnabled, <strong>ReadOnlyRecommended:=True<\/strong>\nEnd Sub<\/pre>\n<h2><span class=\"ez-toc-section\" id=\"Set_a_password_to_modify_an_Excel_spreadsheet\"><\/span>Set a password to modify an Excel spreadsheet<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Making a spreadsheet read only recommended means that anyone can open the spreadsheet, and anyone can still write to it if they choose to.\u00a0 You might want to stop users being able to edit your spreadsheet, for example to prevent accidental changes.<\/p>\n<p>To do this, the process is similar to that for read only recommended: Choose to &#8216;SaveAs&#8217; the workbook to open the SaveAs dialogue box as shown above:<\/p>\n<ul>\n<li>Choose File &gt; Save As from the ribbon .\u00a0 Do this even if you don&#8217;t want to save the workbook with a different filename. Click &#8216;Browse&#8217; on the list of locations to get the &#8220;Save As&#8221; box up, and browse to the location where you want to save the workbook. Alternatively you can press the &#8220;Save As&#8221; shortcut key: F12 on the keyboard.<\/li>\n<li>Enter a filename. If you don&#8217;t want to change the name of the spreadsheet then just leave this the same as the current name.<\/li>\n<li>Next to the save button, click (1) &#8220;Tools&#8221; then (2) &#8220;General Options&#8221;.<\/li>\n<li>In the dialogue box that opens, enter the required password in &#8220;Password to modify&#8221;.\u00a0<img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-38\" src=\"https:\/\/www.excelfinancemastery.com\/wp-content\/uploads\/2022\/09\/readonly_4_password.png\" alt=\"\" width=\"528\" height=\"398\" \/><\/li>\n<li>Press &#8220;OK&#8221; and re-enter the password at the next prompt. Then press OK again<img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-39\" src=\"https:\/\/www.excelfinancemastery.com\/wp-content\/uploads\/2022\/09\/readonly_5_confirm.png\" alt=\"\" width=\"588\" height=\"400\" \/><\/li>\n<li>Finally, save and close the file.\u00a0 The next time it is opened, your users will need to input the password in order to modify it.<\/li>\n<\/ul>\n<h3><span class=\"ez-toc-section\" id=\"Set_a_password_to_modify_a_spreadsheet_using_VBA\"><\/span>Set a password to modify a spreadsheet using VBA<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>Just like setting read only recommended using VBA, adding a password to modify a spreadsheet using VBA is fairly simple.<\/p>\n<p>To do this, include the parameter <code>WriteResPassword:=\"MyPass\"<\/code>\u00a0when calling the <code>Workbook.SaveAs<\/code> routine. Replace &#8220;MyPass&#8221; with whatever you want the password to be set to.\u00a0 For example, the following code will save the current workbook as a macro enabled file called &#8220;MyFile2.xlsm&#8221; which requires a password to edit.<\/p>\n<pre>Sub SaveWorkbook()\n    ThisWorkbook.SaveAs Filename:=\"MyFile2.xlsm\", FileFormat:=xlOpenXMLWorkbookMacroEnabled, _\n                        <strong>WriteResPassword:=\"MyPass\"<\/strong>\nEnd Sub<\/pre>\n<p>It&#8217;s also possible to combine with read only recommended, and set both at the same time using VBA, as in the following example.<\/p>\n<pre>Sub SaveWorkbook2()\n    ThisWorkbook.SaveAs Filename:=\"MyFile2.xlsm\", FileFormat:=xlOpenXMLWorkbookMacroEnabled, _\n                        ReadOnlyRecommended:=True, <strong>WriteResPassword:=\"MyPass\"<\/strong>\nEnd Sub<\/pre>\n<h2><span class=\"ez-toc-section\" id=\"Set_a_password_to_open_an_Excel_spreadsheet\"><\/span>Set a password to open an Excel spreadsheet<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Finally, if your spreadsheet has confidential information, you might need to require a password to open it at all.\u00a0 In more recent versions of Excel, doing so will encrypt the file, such that it&#8217;s data can&#8217;t be easily read from other programs than Excel. This is set in a similar way to the other cases we&#8217;ve discussed above.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Set_password_to_open_in_Excel_365\"><\/span>Set password to open in Excel 365<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>In the newer versions of Excel, such as Excel 365, you can do this via the Info section of the File tab:<\/p>\n<ul>\n<li>Choose &#8216;Protect Workbook&#8217; &gt; Encrypt with Password&#8217;:<img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-large wp-image-48\" style=\"font-size: inherit;\" src=\"https:\/\/www.excelfinancemastery.com\/wp-content\/uploads\/2022\/09\/readonly_7_info_password-1024x472.png\" alt=\"\" width=\"1024\" height=\"472\" \/><\/li>\n<li>Excel will then open another box for you to enter your password. Heed the warning that if you forget the password you will be unable to open the spreadsheet again and will lose your data. Enter your chosen password and press &#8216;OK&#8217;<img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-50\" src=\"https:\/\/www.excelfinancemastery.com\/wp-content\/uploads\/2022\/09\/readonly_8_info_password_box.png\" alt=\"\" width=\"618\" height=\"416\" \/><\/li>\n<li>You&#8217;ll see a similar box asking to confirm your password. Re-enter and press OK.<\/li>\n<li>The spreadsheet will now be password protected &#8211; anyone trying to open the workbook will need to enter this password.<\/li>\n<\/ul>\n<h3><span class=\"ez-toc-section\" id=\"Set_password_to_open_in_earlier_versions_of_Excel\"><\/span>Set password to open in earlier versions of Excel<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>If the above instructions did not work (e.g. you couldn&#8217;t find the File &gt; Info tab of the ribbon), or you don&#8217;t have the ribbon, then follow the steps below instead to add a password from the &#8216;Save As&#8217; dialogue. These are fairly similar to setting &#8216;Read Only Recommended&#8217;, which we covered above.<\/p>\n<ul>\n<li>Choose File &gt; Save As from the ribbon .\u00a0 Do this even if you don&#8217;t want to save the workbook with a different filename. Click &#8216;Browse&#8217; on the list of locations to get the &#8220;Save As&#8221; box up, and browse to the location where you want to save the workbook. Alternatively you can press the &#8220;Save As&#8221; shortcut key: F12 on the keyboard.<\/li>\n<li>Enter a filename. If you don&#8217;t want to change the name of the spreadsheet then just leave this the same as the current name.<\/li>\n<li>Next to the save button, click (1) &#8220;Tools&#8221; then (2) &#8220;General Options&#8221;.<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-large wp-image-36\" src=\"https:\/\/www.excelfinancemastery.com\/wp-content\/uploads\/2022\/09\/readonly_2_saveas-1024x823.png\" alt=\"\" width=\"1024\" height=\"823\" \/><\/p>\n<ul>\n<li>In the dialogue box that opens, enter the required password in &#8220;Password to open&#8221;.\u00a0<img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-49\" src=\"https:\/\/www.excelfinancemastery.com\/wp-content\/uploads\/2022\/09\/readonly_6_open_pw-1.png\" alt=\"\" width=\"524\" height=\"398\" \/><\/li>\n<li>Press &#8220;OK&#8221; and re-enter the password at the next prompt. Then press OK again<\/li>\n<li>Finally, save and close the file.\u00a0 The next time it is opened, your users will need to input the password in order to modify it.<\/li>\n<\/ul>\n<h3><span class=\"ez-toc-section\" id=\"Set_a_password_to_open_a_spreadsheet_using_VBA\"><\/span>Set a password to open a spreadsheet using VBA<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>A final way to set a password to open an Excel spreadsheet is using VBA. To do this, we just need to add an extra argument when calling <code>Workbook.SaveAs<\/code>.\u00a0 In this case, we specify the parameter <code>Password:=\"MyPass\"<\/code> (replace &#8220;MyPass&#8221; with whatever you want the password to be)<\/p>\n<p>For example, the following code will save the current workbook as a macro enabled file called &#8220;MyFile2.xlsm&#8221; which requires a password to open.<\/p>\n<pre>Sub SaveWorkbook()\n    ThisWorkbook.SaveAs Filename:=\"MyFile2.xlsm\", FileFormat:=xlOpenXMLWorkbookMacroEnabled, _\n                        <strong>Password:=\"MyPass\"<\/strong>\nEnd Sub<\/pre>\n<p>Finally, this can be combined with both read only recommended settings, and a separate password to modify by including those parameters too, as in the following example.<\/p>\n<pre>Sub SaveWorkbook2()\n    ThisWorkbook.SaveAs Filename:=\"MyFile2.xlsm\", FileFormat:=xlOpenXMLWorkbookMacroEnabled, _\n                        ReadOnlyRecommended:=True, WriteResPassword:=\"SecretPass\", <strong>Password:=\"Pass\"<\/strong>\nEnd Sub<\/pre>\n<h2 id=\"remove-read-only\"><span class=\"ez-toc-section\" id=\"Remove_read_only_recommended_or_password_from_an_Excel_spreadsheet\"><\/span>Remove read only recommended or password from an Excel spreadsheet<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Finally, if you want to stop a file from being read only recommended, or remove a password to open\/modify, then you&#8217;ll just need to follow the above steps in reverse.\u00a0 Note that you will need the password to open the file in order to do this, but you don&#8217;t need any password to modify it.<\/p>\n<ul>\n<li>Choose File &gt; Save As from the ribbon .\u00a0 Do this even if you don&#8217;t want to save the workbook with a different filename. Click &#8216;Browse&#8217; on the list of locations to get the &#8220;Save As&#8221; box up, and browse to the location where you want to save the workbook. Alternatively you can press the &#8220;Save As&#8221; shortcut key: F12 on the keyboard.<\/li>\n<li>Enter a filename. If you don&#8217;t want to change the name of the spreadsheet then just leave this the same as the current name.<\/li>\n<li>Next to the save button, click (1) &#8220;Tools&#8221; then (2) &#8220;General Options&#8221;.<\/li>\n<li>In the dialogue box that opens, uncheck &#8216;Read only recommened&#8217; and set the passwords to blank (as required).<img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-54\" src=\"https:\/\/www.excelfinancemastery.com\/wp-content\/uploads\/2022\/09\/readonly_9_remove_password.png\" alt=\"\" width=\"524\" height=\"398\" \/><\/li>\n<li>Then press &#8216;OK&#8217;, enter a filename and press Save.\u00a0 Note that if you have opened the file as read only, you will need to enter a different filename. If needed, you can then delete\/archive the original file and rename yours using Windows Explorer.<\/li>\n<\/ul>\n<h2><span class=\"ez-toc-section\" id=\"Wrap_up\"><\/span>Wrap up<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>In this article we&#8217;ve covered how to:<\/p>\n<ul>\n<li>Set read only recommended in Excel and VBA<\/li>\n<li>Add a password to modify a spreadsheet in Excel and VBA<\/li>\n<li>Add a password to open a spreadsheet in Excel and VBA<\/li>\n<li>Remove read only recommended and passwords from Excel spreadsheets.<\/li>\n<\/ul>\n<p>If you have any questions, please leave a comment.<\/p>\n<h2><span class=\"ez-toc-section\" id=\"References\"><\/span>References<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<ul>\n<li><a href=\"https:\/\/support.microsoft.com\/en-us\/office\/prompt-to-open-a-workbook-as-read-only-f41e48ed-9561-4bdd-b33e-34b8ddc0beb5#:~:text=Open%20the%20workbook%20that%20you,check%20box%2C%20and%20click%20OK.\">Microsoft &#8211; Prompt to open a workbook as read-only<\/a><\/li>\n<li><a href=\"https:\/\/support.microsoft.com\/en-us\/office\/protect-an-excel-file-7359d4ae-7213-4ac2-b058-f75e9311b599\">Microsoft &#8211; Protect an Excel File<\/a><\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>In this guide, we&#8217;ll explain how to set read only recommended in Excel. That means that whenever someone opens it, Excel will suggest they open it as read only. While setting read only recommended can prevent accidental modifications, users can still choose not to open as read only, so we&#8217;ll also cover adding passwords to &#8230; <a title=\"Set Read Only Recommended in Excel\" class=\"read-more\" href=\"https:\/\/www.tiposaurus.co.uk\/set-read-only-recommended-in-excel\/\" aria-label=\"More on Set Read Only Recommended in Excel\">Read more<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[7],"tags":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v21.9.1 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Set Read Only Recommended in Excel - Tiposaurus<\/title>\n<meta name=\"description\" content=\"A complete guide to setting read only recommended and adding passwords to open or modify Excel spreadsheets.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.tiposaurus.co.uk\/set-read-only-recommended-in-excel\/\" \/>\n<meta property=\"og:locale\" content=\"en_GB\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Set Read Only Recommended in Excel - Tiposaurus\" \/>\n<meta property=\"og:description\" content=\"A complete guide to setting read only recommended and adding passwords to open or modify Excel spreadsheets.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.tiposaurus.co.uk\/set-read-only-recommended-in-excel\/\" \/>\n<meta property=\"og:site_name\" content=\"Tiposaurus\" \/>\n<meta property=\"article:published_time\" content=\"2022-09-14T11:54:19+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-01-26T23:23:18+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.excelfinancemastery.com\/wp-content\/uploads\/2022\/09\/readonly_1_info-1024x453.png\" \/>\n<meta name=\"author\" content=\"Steven\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Steven\" \/>\n\t<meta name=\"twitter:label2\" content=\"Estimated reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"11 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.tiposaurus.co.uk\/set-read-only-recommended-in-excel\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.tiposaurus.co.uk\/set-read-only-recommended-in-excel\/\"},\"author\":{\"name\":\"Steven\",\"@id\":\"https:\/\/www.tiposaurus.co.uk\/#\/schema\/person\/94552b25c2fb53129269a0474088930c\"},\"headline\":\"Set Read Only Recommended in Excel\",\"datePublished\":\"2022-09-14T11:54:19+00:00\",\"dateModified\":\"2024-01-26T23:23:18+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.tiposaurus.co.uk\/set-read-only-recommended-in-excel\/\"},\"wordCount\":1865,\"publisher\":{\"@id\":\"https:\/\/www.tiposaurus.co.uk\/#organization\"},\"articleSection\":[\"Excel\"],\"inLanguage\":\"en-GB\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.tiposaurus.co.uk\/set-read-only-recommended-in-excel\/\",\"url\":\"https:\/\/www.tiposaurus.co.uk\/set-read-only-recommended-in-excel\/\",\"name\":\"Set Read Only Recommended in Excel - Tiposaurus\",\"isPartOf\":{\"@id\":\"https:\/\/www.tiposaurus.co.uk\/#website\"},\"datePublished\":\"2022-09-14T11:54:19+00:00\",\"dateModified\":\"2024-01-26T23:23:18+00:00\",\"description\":\"A complete guide to setting read only recommended and adding passwords to open or modify Excel spreadsheets.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.tiposaurus.co.uk\/set-read-only-recommended-in-excel\/#breadcrumb\"},\"inLanguage\":\"en-GB\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.tiposaurus.co.uk\/set-read-only-recommended-in-excel\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.tiposaurus.co.uk\/set-read-only-recommended-in-excel\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.tiposaurus.co.uk\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Set Read Only Recommended in Excel\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.tiposaurus.co.uk\/#website\",\"url\":\"https:\/\/www.tiposaurus.co.uk\/\",\"name\":\"Tiposaurus\",\"description\":\"Technology, Productivity and Development\",\"publisher\":{\"@id\":\"https:\/\/www.tiposaurus.co.uk\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.tiposaurus.co.uk\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-GB\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.tiposaurus.co.uk\/#organization\",\"name\":\"Tiposaurus\",\"url\":\"https:\/\/www.tiposaurus.co.uk\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-GB\",\"@id\":\"https:\/\/www.tiposaurus.co.uk\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/www.tiposaurus.co.uk\/wp-content\/uploads\/2023\/12\/cropped-cropped-tiposaurus-logo-small-e1702978467185.png\",\"contentUrl\":\"https:\/\/www.tiposaurus.co.uk\/wp-content\/uploads\/2023\/12\/cropped-cropped-tiposaurus-logo-small-e1702978467185.png\",\"width\":133,\"height\":97,\"caption\":\"Tiposaurus\"},\"image\":{\"@id\":\"https:\/\/www.tiposaurus.co.uk\/#\/schema\/logo\/image\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.tiposaurus.co.uk\/#\/schema\/person\/94552b25c2fb53129269a0474088930c\",\"name\":\"Steven\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-GB\",\"@id\":\"https:\/\/www.tiposaurus.co.uk\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/70dad3cfd851615162ae18a230e533e3?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/70dad3cfd851615162ae18a230e533e3?s=96&d=mm&r=g\",\"caption\":\"Steven\"},\"sameAs\":[\"https:\/\/www.tiposaurus.co.uk\"],\"url\":\"https:\/\/www.tiposaurus.co.uk\/author\/steven\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Set Read Only Recommended in Excel - Tiposaurus","description":"A complete guide to setting read only recommended and adding passwords to open or modify Excel spreadsheets.","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:\/\/www.tiposaurus.co.uk\/set-read-only-recommended-in-excel\/","og_locale":"en_GB","og_type":"article","og_title":"Set Read Only Recommended in Excel - Tiposaurus","og_description":"A complete guide to setting read only recommended and adding passwords to open or modify Excel spreadsheets.","og_url":"https:\/\/www.tiposaurus.co.uk\/set-read-only-recommended-in-excel\/","og_site_name":"Tiposaurus","article_published_time":"2022-09-14T11:54:19+00:00","article_modified_time":"2024-01-26T23:23:18+00:00","og_image":[{"url":"https:\/\/www.excelfinancemastery.com\/wp-content\/uploads\/2022\/09\/readonly_1_info-1024x453.png"}],"author":"Steven","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Steven","Estimated reading time":"11 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.tiposaurus.co.uk\/set-read-only-recommended-in-excel\/#article","isPartOf":{"@id":"https:\/\/www.tiposaurus.co.uk\/set-read-only-recommended-in-excel\/"},"author":{"name":"Steven","@id":"https:\/\/www.tiposaurus.co.uk\/#\/schema\/person\/94552b25c2fb53129269a0474088930c"},"headline":"Set Read Only Recommended in Excel","datePublished":"2022-09-14T11:54:19+00:00","dateModified":"2024-01-26T23:23:18+00:00","mainEntityOfPage":{"@id":"https:\/\/www.tiposaurus.co.uk\/set-read-only-recommended-in-excel\/"},"wordCount":1865,"publisher":{"@id":"https:\/\/www.tiposaurus.co.uk\/#organization"},"articleSection":["Excel"],"inLanguage":"en-GB"},{"@type":"WebPage","@id":"https:\/\/www.tiposaurus.co.uk\/set-read-only-recommended-in-excel\/","url":"https:\/\/www.tiposaurus.co.uk\/set-read-only-recommended-in-excel\/","name":"Set Read Only Recommended in Excel - Tiposaurus","isPartOf":{"@id":"https:\/\/www.tiposaurus.co.uk\/#website"},"datePublished":"2022-09-14T11:54:19+00:00","dateModified":"2024-01-26T23:23:18+00:00","description":"A complete guide to setting read only recommended and adding passwords to open or modify Excel spreadsheets.","breadcrumb":{"@id":"https:\/\/www.tiposaurus.co.uk\/set-read-only-recommended-in-excel\/#breadcrumb"},"inLanguage":"en-GB","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.tiposaurus.co.uk\/set-read-only-recommended-in-excel\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.tiposaurus.co.uk\/set-read-only-recommended-in-excel\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.tiposaurus.co.uk\/"},{"@type":"ListItem","position":2,"name":"Set Read Only Recommended in Excel"}]},{"@type":"WebSite","@id":"https:\/\/www.tiposaurus.co.uk\/#website","url":"https:\/\/www.tiposaurus.co.uk\/","name":"Tiposaurus","description":"Technology, Productivity and Development","publisher":{"@id":"https:\/\/www.tiposaurus.co.uk\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.tiposaurus.co.uk\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-GB"},{"@type":"Organization","@id":"https:\/\/www.tiposaurus.co.uk\/#organization","name":"Tiposaurus","url":"https:\/\/www.tiposaurus.co.uk\/","logo":{"@type":"ImageObject","inLanguage":"en-GB","@id":"https:\/\/www.tiposaurus.co.uk\/#\/schema\/logo\/image\/","url":"https:\/\/www.tiposaurus.co.uk\/wp-content\/uploads\/2023\/12\/cropped-cropped-tiposaurus-logo-small-e1702978467185.png","contentUrl":"https:\/\/www.tiposaurus.co.uk\/wp-content\/uploads\/2023\/12\/cropped-cropped-tiposaurus-logo-small-e1702978467185.png","width":133,"height":97,"caption":"Tiposaurus"},"image":{"@id":"https:\/\/www.tiposaurus.co.uk\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/www.tiposaurus.co.uk\/#\/schema\/person\/94552b25c2fb53129269a0474088930c","name":"Steven","image":{"@type":"ImageObject","inLanguage":"en-GB","@id":"https:\/\/www.tiposaurus.co.uk\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/70dad3cfd851615162ae18a230e533e3?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/70dad3cfd851615162ae18a230e533e3?s=96&d=mm&r=g","caption":"Steven"},"sameAs":["https:\/\/www.tiposaurus.co.uk"],"url":"https:\/\/www.tiposaurus.co.uk\/author\/steven\/"}]}},"jetpack_sharing_enabled":true,"jetpack_featured_media_url":"","jetpack-related-posts":[{"id":58,"url":"https:\/\/www.tiposaurus.co.uk\/display-the-weekday-as-text-in-excel\/","url_meta":{"origin":131,"position":0},"title":"Display the Weekday as Text in Excel","author":"Steven","date":"September 19, 2022","format":false,"excerpt":"I often want to know what day of the week a date is. The obvious choice in Excel is the WEEKDAY() function for this; however it only returns an integer. For example, the formula: =WEEKDAY(\"01\/02\/2009\") returns 1 (which represents Sunday). In this article, I'll describe the various ways which you\u2026","rel":"","context":"In &quot;Excel&quot;","block_context":{"text":"Excel","link":"https:\/\/www.tiposaurus.co.uk\/category\/archive\/excel\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":130,"url":"https:\/\/www.tiposaurus.co.uk\/excel-minifs-function\/","url_meta":{"origin":131,"position":1},"title":"How to use MINIFS in Excel","author":"Steven","date":"August 30, 2022","format":false,"excerpt":"You'll likely be familiar with the MIN function for taking the value of a range: MIN(A1:A5) will return the minimum value in cells A1:A5.\u00a0 If you need to take a conditional minimum, which applies to only some of the values in that range, without splitting your data up, then the\u2026","rel":"","context":"In &quot;Functions&quot;","block_context":{"text":"Functions","link":"https:\/\/www.tiposaurus.co.uk\/category\/functions\/"},"img":{"alt_text":"example example and uses of MINIFS","src":"https:\/\/i0.wp.com\/www.excelfinancemastery.com\/wp-content\/uploads\/2022\/08\/1.-minifs-data-e1661470827100.png?resize=350%2C200&ssl=1","width":350,"height":200},"classes":[]},{"id":135,"url":"https:\/\/www.tiposaurus.co.uk\/how-to-calculate-net-present-values-in-excel\/","url_meta":{"origin":131,"position":2},"title":"How to Calculate Net Present Values in Excel","author":"Steven","date":"April 11, 2023","format":false,"excerpt":"Introduction Net Present Value (NPV) is a widely used financial metric that helps investors and business managers to evaluate the profitability of an investment or project. NPV calculates the difference between the present value of cash inflows and the present value of cash outflows over a certain period. A positive\u2026","rel":"","context":"In &quot;Excel&quot;","block_context":{"text":"Excel","link":"https:\/\/www.tiposaurus.co.uk\/category\/archive\/excel\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":134,"url":"https:\/\/www.tiposaurus.co.uk\/excel-tips-and-tricks-for-financial-modeling\/","url_meta":{"origin":131,"position":3},"title":"Excel Tips and Tricks for Financial Modeling","author":"Steven","date":"April 10, 2023","format":false,"excerpt":"Financial modeling is an essential skill for finance professionals, allowing them to project financial performance, evaluate investment opportunities, and make informed decisions. Microsoft Excel is the go-to software for building financial models, thanks to its flexibility, functionality, and ease of use. In this blog post, we'll share tips and tricks\u2026","rel":"","context":"In &quot;Excel&quot;","block_context":{"text":"Excel","link":"https:\/\/www.tiposaurus.co.uk\/category\/archive\/excel\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":133,"url":"https:\/\/www.tiposaurus.co.uk\/5-excel-formulas-every-finance-professional-should-know\/","url_meta":{"origin":131,"position":4},"title":"5 Excel Formulas Every Finance Professional Should Know","author":"Steven","date":"April 10, 2023","format":false,"excerpt":"The Importance of Excel in Finance As a finance professional, you already know that Excel is an essential tool in your day-to-day work. It's a powerful software that allows for efficient data manipulation, analysis, and reporting. The true magic of Excel lies in its formulas, which can help you automate\u2026","rel":"","context":"In &quot;Functions&quot;","block_context":{"text":"Functions","link":"https:\/\/www.tiposaurus.co.uk\/category\/functions\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":71,"url":"https:\/\/www.tiposaurus.co.uk\/the-dictionary-object-in-excel-vba-definitive-guide\/","url_meta":{"origin":131,"position":5},"title":"The Dictionary Object in Excel VBA &#8211; Definitive Guide","author":"Steven","date":"April 11, 2023","format":false,"excerpt":"1. Introduction This guide aims to provide a comprehensive understanding of the Dictionary object in Excel VBA, including an overview of its features and the advantages it offers over other data structures like arrays and collections. We will also cover how to include the necessary library, create a dictionary, add\u2026","rel":"","context":"In &quot;VBA&quot;","block_context":{"text":"VBA","link":"https:\/\/www.tiposaurus.co.uk\/category\/vba\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]}],"_links":{"self":[{"href":"https:\/\/www.tiposaurus.co.uk\/wp-json\/wp\/v2\/posts\/131"}],"collection":[{"href":"https:\/\/www.tiposaurus.co.uk\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.tiposaurus.co.uk\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.tiposaurus.co.uk\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.tiposaurus.co.uk\/wp-json\/wp\/v2\/comments?post=131"}],"version-history":[{"count":1,"href":"https:\/\/www.tiposaurus.co.uk\/wp-json\/wp\/v2\/posts\/131\/revisions"}],"predecessor-version":[{"id":154,"href":"https:\/\/www.tiposaurus.co.uk\/wp-json\/wp\/v2\/posts\/131\/revisions\/154"}],"wp:attachment":[{"href":"https:\/\/www.tiposaurus.co.uk\/wp-json\/wp\/v2\/media?parent=131"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.tiposaurus.co.uk\/wp-json\/wp\/v2\/categories?post=131"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.tiposaurus.co.uk\/wp-json\/wp\/v2\/tags?post=131"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}