+ Reply to Thread
Results 1 to 4 of 4

AutoFilter 2003 Excel Protected Sheet

  1. #1
    bdehning
    Guest

    AutoFilter 2003 Excel Protected Sheet

    I followed instruction to protect sheet and allow autofilter but still Excel
    2003 sheet will not give me option to autofilter.

    I used tools, protection, protect sheet. Next I selected Use AutoFilter and
    clicked OK. But the only thing it allows me to do is Advanced Filter.

    Is there something else I have to change that may be set wrong by default
    somewhere? I know this should work.
    --
    Brian

  2. #2
    Dave Peterson
    Guest

    Re: AutoFilter 2003 Excel Protected Sheet

    The worksheet already has to have the autofilter arrows applied when you protect
    the sheet.

    Could that have been your problem?

    bdehning wrote:
    >
    > I followed instruction to protect sheet and allow autofilter but still Excel
    > 2003 sheet will not give me option to autofilter.
    >
    > I used tools, protection, protect sheet. Next I selected Use AutoFilter and
    > clicked OK. But the only thing it allows me to do is Advanced Filter.
    >
    > Is there something else I have to change that may be set wrong by default
    > somewhere? I know this should work.
    > --
    > Brian


    --

    Dave Peterson

  3. #3
    bdehning
    Guest

    RE: AutoFilter 2003 Excel Protected Sheet

    Yes, I have made sure that all cells are not locked as well as I have got
    sort to work when protected.

    Still no luck on Autofilter!
    --
    Brian


    "bdehning" wrote:

    > I followed instruction to protect sheet and allow autofilter but still Excel
    > 2003 sheet will not give me option to autofilter.
    >
    > I used tools, protection, protect sheet. Next I selected Use AutoFilter and
    > clicked OK. But the only thing it allows me to do is Advanced Filter.
    >
    > Is there something else I have to change that may be set wrong by default
    > somewhere? I know this should work.
    > --
    > Brian


  4. #4
    bdehning
    Guest

    Re: AutoFilter 2003 Excel Protected Sheet

    That was it.

    Thank You.
    --
    Brian


    "Dave Peterson" wrote:

    > The worksheet already has to have the autofilter arrows applied when you protect
    > the sheet.
    >
    > Could that have been your problem?
    >
    > bdehning wrote:
    > >
    > > I followed instruction to protect sheet and allow autofilter but still Excel
    > > 2003 sheet will not give me option to autofilter.
    > >
    > > I used tools, protection, protect sheet. Next I selected Use AutoFilter and
    > > clicked OK. But the only thing it allows me to do is Advanced Filter.
    > >
    > > Is there something else I have to change that may be set wrong by default
    > > somewhere? I know this should work.
    > > --
    > > Brian

    >
    > --
    >
    > Dave Peterson
    >


+ 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