+ Reply to Thread
Results 1 to 5 of 5

Password Protect a Worksheet

Hybrid View

  1. #1
    joinme4coffee
    Guest

    Password Protect a Worksheet

    Help! I am trying to password protect a worksheet and the "Password to open"
    box is not available. The "password to edit" box is OK.

  2. #2
    salooha
    Guest

    RE: Password Protect a Worksheet

    hi there,
    if you go file --> save as --> then click on tools --> general options,
    there should be a couple of entry boxes, one for password to open and the
    other is for password to modify. this is one way to password protect the
    worksheet from opening without authorization.

    the other way which I am assuming you're asking about is if you go to tools
    --> options --> 'security' tab. there should be two entry boxes as well, one
    says password to open and the other password to modify..is this what you're
    talking about??

    can you please ellaborate a little?

    --
    Thanks,
    salah
    http://leitek.com

    "joinme4coffee" wrote:

    > Help! I am trying to password protect a worksheet and the "Password to open"
    > box is not available. The "password to edit" box is OK.


  3. #3
    joinme4coffee
    Guest

    RE: Password Protect a Worksheet

    I am using the first option you list. The entry box for password to open is
    grayed out. the box for password to modify is available

    Thanks for your help!

    "salooha" wrote:

    > hi there,
    > if you go file --> save as --> then click on tools --> general options,
    > there should be a couple of entry boxes, one for password to open and the
    > other is for password to modify. this is one way to password protect the
    > worksheet from opening without authorization.
    >
    > the other way which I am assuming you're asking about is if you go to tools
    > --> options --> 'security' tab. there should be two entry boxes as well, one
    > says password to open and the other password to modify..is this what you're
    > talking about??
    >
    > can you please ellaborate a little?
    >
    > --
    > Thanks,
    > salah
    > http://leitek.com
    >
    > "joinme4coffee" wrote:
    >
    > > Help! I am trying to password protect a worksheet and the "Password to open"
    > > box is not available. The "password to edit" box is OK.


  4. #4
    Gord Dibben
    Guest

    Re: Password Protect a Worksheet

    My guess is that the file is shared.

    The "password to open" will be grayed out in that case.


    Gord Dibben Excel MVP

    On Mon, 15 Aug 2005 12:27:02 -0700, "joinme4coffee"
    <joinme4coffee@discussions.microsoft.com> wrote:

    >I am using the first option you list. The entry box for password to open is
    >grayed out. the box for password to modify is available
    >
    >Thanks for your help!
    >
    >"salooha" wrote:
    >
    >> hi there,
    >> if you go file --> save as --> then click on tools --> general options,
    >> there should be a couple of entry boxes, one for password to open and the
    >> other is for password to modify. this is one way to password protect the
    >> worksheet from opening without authorization.
    >>
    >> the other way which I am assuming you're asking about is if you go to tools
    >> --> options --> 'security' tab. there should be two entry boxes as well, one
    >> says password to open and the other password to modify..is this what you're
    >> talking about??
    >>
    >> can you please ellaborate a little?
    >>
    >> --
    >> Thanks,
    >> salah
    >> http://leitek.com
    >>
    >> "joinme4coffee" wrote:
    >>
    >> > Help! I am trying to password protect a worksheet and the "Password to open"
    >> > box is not available. The "password to edit" box is OK.



  5. #5
    Gord Dibben
    Guest

    Re: Password Protect a Worksheet

    If you really mean "worksheet" and not "file" then click on
    Tools>Protection>Protect Sheet(or workbook).


    Gord Dibben Excel MVP

    On Mon, 15 Aug 2005 11:47:08 -0700, "joinme4coffee"
    <joinme4coffee@discussions.microsoft.com> wrote:

    >Help! I am trying to password protect a worksheet and the "Password to open"
    >box is not available. The "password to edit" box is OK.



+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1