HOW TO MAKE EXCEL SHEET READ ONLY HOW TO
HOW TO MAKE EXCEL SHEET READ ONLY PASSWORD

You'll still get the popup when you try to edit things.(In fact, thanks to default values, you can drop everything on that line after. To change that, drop the last True after. As written, it only locks the user interface.

HOW TO MAKE EXCEL SHEET READ ONLY PASSWORD

'When disabling protection, it will prompt for a password only if it isn't blank For parsing, the first step is to read the file. 'Enables / Disables sheet protection with a blank password greenbook: SheetJS Community Edition - Spreadsheet Data Toolkit - GitHub - SheetJS/sheetjs: SheetJS. Once you add it, you can edit the icon and name. Set drop-down in the top left labeled 'Choose commands from:' to be 'Macros' and then find the macro in the list. There is a setting to save the file as read-only recommended. In brief, though: Right-click in an open space on the ribbon and click 'Customize the Quick Access Toolbar' or 'Customize the Ribbon' to open a new window.

HOW TO MAKE EXCEL SHEET READ ONLY HOW TO

This article can offer all the details of how to add custom macros to the ribbon or quick-access toolbar. You can use this to make a single button that turns it on and off. Here's the VBA to toggle sheet protection. I would recommend, though, not checking all the boxes when you protect it because doing so would allow you to add / delete rows & columns - among other things - which you probably don't want to do. I.E., it doesn't save you very much time. The popup boxes when you try to edit a cell will still occur. It would be easy enough to use but you'd have to put a button on your toolbar somewhere to call that macro. You could write some VBA to automatically protect and unprotect the sheet with a blank password. There are a few annoyance like having to deal with a dialog box when you turn it on and dealing with a popup box whenever you try to edit a cell. You've already stated that protecting the sheet with a blank password is not the approach you want but it's certainly the simplest. Make it impossible to edit the sheet until you click a specific button It's not very robust and it's annoying to apply but quick to remove. This idea serves mostly as a reminder since it's easy to simply delete the shape and use the sheet normally. However, it would still be possible to use the keyboard to navigate around and edit the cells under the shapes. This will allow you to see everything but prevent you from clicking on any of the cells. If it's to prevent yourself from accidentally editing the sheet, one solution is to draw giant rectangle that covers all your data and set it's transparency to 100%. Remind yourself that you don't want to edit this sheet

How to make excel sheet read only