Discussion in 'Software' started by Becky, Jun 30, 2003.

  1. Becky

    Becky New Member

    How do I pasword protect a spreadsheet, so you have to enter a password before you can open it :mad: :mad: :mad: :mad:
  2. Beenz75

    Beenz75 Bit Poster

    Im not quite sure if you mean a single worksheet of the entire workbook. To save the workbook, open the Save As dialouge box and click on the tools menu and choose general options.
  3. Rosy
    Honorary Member

    Rosy Megabyte Poster

    Hi Becky - glad to see that you have also joined.

    In reply to Beenz75 instructions I believe that you are wanting to put a password on the entire workbook so need to choose the File > Save As > Tools > General Options and then enter the password you wish to set in the Password to Open section and then another dialogue box will appear - in here you need to confirm the password. If you don't want people to modify the spreadsheet then you can set a password for this also in the same place.
    Certifications: MOS Master Instructor

Share This Page

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.