how to make a file read only in Excel

Q134. After several iterations, I have finalized my WorkBook - how do I make it Read-only from then on to prevent further edits?

To do it in Excel, here is the answer:

a) Click on "Info" under "File". Click on "Mark as Final" under "Protect WorkBook".

excel how to make a file read only

b) Click on "OK" in the pop up message indicating "This WorkBook will be marked as final and then saved." The WorkBook is now "Read-Only".

excel excel how to make a file read only


You can find similar Excel Questions and Answer hereunder

1) How can I dynamically add series to an existing chart using VBA?

2) I am using Excel for Project Management - how can I find End Date for a task given Start Date and Task duration considering only working days?

3) How can I extract file name from a full path?

4) How can I have text autocomplete by typing in a short code for the text?

5) How can I generate random numbers between 2 limits?

6) How can I show summary reports with Totals only hiding all the rows containing the details?

7) Write to text file without quotes in vba in Excel

8) I have data arranged in rows of information. Is there any way I can enter new data through a form instead of entering it directly in SpreadSheet?

9) Converting numbers stored as text to numbers via macro in Excel

10) I am planning to protect my sheet using a password. However, for select cells I would like users to be able to edit the cells. In Excel, how can I achieve that?

11) How can I extract file name from a full path including folder path and file name?

12) How can I get users to select a folder to save the output of my macro?

13) How can I check if a file exists in a folder using VBA?

14) How to read a value from a cell in vba in Excel

15) How can I change the meta-data of file (Author, Company Name and the like)?