How do you force an Excel File to open as read only?

How do you force an Excel File to open as read only?

Excel: Force “Open as Read Only” Prompt

1. In Excel, select “File” and click Save As.
2. Ensure the file format box is set to “Excel Workbook“, then select “More options…“.
3. Choose “Tools” > “General Options” at the bottom of the window.
4. Select the check-box for “Read-only recommended“, then select “OK“.
5. Select “Save“.

How do I make a File read only except for me?

Save as read only

1. Click the Microsoft Office Button. , and then click Save or Save As if you have previously saved the document.
2. Click Tools.
3. Click General Options.
4. Click the Read-only recommended check box.
5. Click OK.
6. Save the document.

How do I protect my macros from editing?

To protect your code, open the Excel Workbook and go to Tools>Macro>Visual Basic Editor (Alt+F11). Now, from within the VBE go to Tools>VBAProject Properties and then click the Protection page tab and then check “Lock project from viewing” and then enter your password and again to confirm it.

How do I open a file as read only?

Open a file as read only with the main menuEdit

1. Click on File -> Open…
2. Select the Word file.
3. Click on the arrow on the “Open” button.
4. Click on “Open as read only”

How do I change a file from read only to edit?

Read-only Files

1. Open Windows Explorer and navigate to the file you want to edit.
2. Right-click the file name and select “Properties.”
3. Select the “General” tab and clear the “Read-only” check box to remove the read-only attribute or select the check the box to set it.

How can I change a read only document?

Some read-only files can be changed to allow for edits by removing the read-only attribute in the file properties.

1. Right-click the file and select Properties.
2. Uncheck the box for Read-only and click OK.

How do I lock a VBA code from viewing?

Here’s how to do it:

1. In Access, press ALT+F11 to open the VBA editor.
2. On the Tools menu, select Properties…
3. On the Protection tab, select the Lock project for viewing check box.
4. Enter and confirm a password.
5. Click OK, and then close and reopen the database.

Can macros be hidden in Excel?

You can also do this by placing the macros you want to hide in a separate module and using Option Private Module at the top of the module before the code. The macros will still be available to your project but will not appear in the Macros seen by the user when he clicks the Macros button. Worked like charm. Thank you!