DW Faisalabad New Version

DW Faisalabad New Version
Please Jump to New Version
  • Working with Tables
  • While there are four types of database objects in Access, tables are arguably the most ... read more

    Monday, 8 May 2017

    Read-only Workbook

    This example shows you how to make your workbook read-only. Users can still save changes by creating a new copy of the workbook. For a better protection, protect a sheet.

    1. Open a workbook.

    2. On the File tab, click Save As.

    3. Click Browse.



    4. Click on the Tools button and click General Options.



    5. In the Password to modify box, enter a password and click OK.



    Note: If you only want to recommend users to open the Excel file as read-only, without protecting it, don't enter a password and check Read-only recommended.

    6. Reenter the password and click on OK.



    Note: this feature does not encrypt your Excel file. Malicious users can edit the file and remove the password.

    7. Enter a file name and click Save.



    Your workbook is read-only now. The password for the downloadable Excel file is "easy".
    .