Results 1 to 6 of 6
  1. #1
    3 Star Lounger
    Join Date
    Apr 2001
    Posts
    304
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Seemingly simple question about protecting files (Excel 2000)

    In Word you can password protect a file so that no one can open the file without that password. Can you do the same thing in Excel? If so, how? I know that you can go to Tools | Protection and protect the structure of the worksheet, but this doesn't actually prevent people from opening it. Thanks. This might be simple, but my brain's not working today.

  2. #2
    3 Star Lounger
    Join Date
    Apr 2001
    Posts
    304
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Seemingly simple question about protecting files (Excel 2000)

    Okay - brain kicked in. Go to File | Save As. In Save As screen, go to Tools | General Options. Can set password to open there.

    I love it when I answer my own question. <img src=/S/bravo.gif border=0 alt=bravo width=16 height=30>

  3. #3
    3 Star Lounger
    Join Date
    Nov 2004
    Location
    Nottingham, Nottinghamshire, United Kingdom
    Posts
    326
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Seemingly simple question about protecting files (Excel 2000)

    You certainly can.

    Choose File>Save As, then select Tools from the toolbar.

    From the drop-down list select General Options, then type your password into the 'Password To Open' box.

    HTH
    <font color=448800><font face="Comic Sans MS"><big>Lyra J </font color=448800></font face=comic></big>
    <img src=/S/flags/UK.gif border=0 alt=UK width=30 height=18> Ducking the arrows in Robin Hood country <IMG SRC=http://www.wopr.com/w3tuserpics/Lyra_J_sig.gif ALT="No, Admins, no! I'm sorry, okay!" title="No, Admins, no! I'm sorry, okay!">

  4. #4
    3 Star Lounger
    Join Date
    Nov 2004
    Location
    Nottingham, Nottinghamshire, United Kingdom
    Posts
    326
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Seemingly simple question about protecting files (Excel 2000)

    <img src=/S/clapping.gif border=0 alt=clapping width=19 height=23> Glad you found it!
    <font color=448800><font face="Comic Sans MS"><big>Lyra J </font color=448800></font face=comic></big>
    <img src=/S/flags/UK.gif border=0 alt=UK width=30 height=18> Ducking the arrows in Robin Hood country <IMG SRC=http://www.wopr.com/w3tuserpics/Lyra_J_sig.gif ALT="No, Admins, no! I'm sorry, okay!" title="No, Admins, no! I'm sorry, okay!">

  5. #5
    3 Star Lounger
    Join Date
    Apr 2001
    Posts
    304
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Seemingly simple question about protecting files (Excel 2000)

    Thank you Lyra - we were both posting the solution at the same time, apparently. Great minds think alike.

  6. #6
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: Seemingly simple question about protecting files (Excel 2000)

    File - save as {options]
    You are given a spot to add a password to open the file, or (as I frequently use in files that multiple people can view) a password to modify (If you use the modify and they do not enter it, it is just opened read-only..)

    Steve

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •