To clear the check mark, click Restrict Formatting and Editing under Restrict Reviewing Options. Open Workbook as Read-Only Using VBA Any workbook can be opened as Read-Onlyusing VBA. Excel and Read Only Spreadsheets You can have Excel make a spreadsheet in read only format for others, so that people can read its contents but not edit them, or you can enforce. Selecting this option will open the file as Read-Only. Click on the arrow of the Opencommand button at the bottom-right of the dialog box and select Open Read-Onlyfrom the list. In the Restrict Formatting and Editing task pane, under Formatting restrictions, Editing restrictions, and Start enforcement, make the selections that meet your formatting and editing needs. Browse and select the file you want to open as Read-Only. Then, click Protect Document and choose one of the options presented. Under Restrict Reviewing Options, click Restrict Formatting and Editing. To do so, click the File tab in the ribbon menu, then click Info. On the Review tab, in the Protect group, click Protect Document. You can stop content reviewers from accidentally modifying your document when you restrict formatting and editing. Top of page Restrict formatting and editing You might need to save it as another file name if you have already named the document.Ĭlear the Read-only recommended check box. Click the Microsoft Office Button, and then click Save or Save As if you have previously saved the document.Ĭlick the Read-only recommended check box.
0 Comments
Leave a Reply. |