Results 1 to 9 of 9
  1. #1
    3 Star Lounger
    Join Date
    Jun 2005
    Posts
    387
    Thanks
    3
    Thanked 0 Times in 0 Posts

    Protecting only sections of a work sheet

    The worksheet I am working on is partially a download of data and part formulas. I want to be able to protect and hide the formula columns while keeping the download section unprotected. I would also like to have the use have access to a row which will filter certain formula columns.

    Are these two things doable in Excel 2007?

    1> protecting only certain sections of a worksheet
    2> allowing the use of a filter for the protected sections

    If so how do I accomplish this.

    Thank you.

  2. #2
    WS Lounge VIP rory's Avatar
    Join Date
    Dec 2000
    Location
    Burwash, East Sussex, United Kingdom
    Posts
    6,280
    Thanks
    3
    Thanked 191 Times in 177 Posts
    Yes - when you protect a sheet:
    1. You can specify in the Format Cells dialog which cells are locked and which are not.
    2. You can allow the use of autofilter. note that this option only allows the use of a previously set up autofilter - the users can change its values but they cannot remove the autofilter itself, or apply a new one.
    Regards,
    Rory

    Microsoft MVP - Excel

  3. #3
    3 Star Lounger
    Join Date
    Jun 2005
    Posts
    387
    Thanks
    3
    Thanked 0 Times in 0 Posts
    Thanks Rory. However, I have followed the procedure as outlined and am not able to accomplish this. Could you be so kind as to laying out the specific steps

  4. #4
    WS Lounge VIP rory's Avatar
    Join Date
    Dec 2000
    Location
    Burwash, East Sussex, United Kingdom
    Posts
    6,280
    Thanks
    3
    Thanked 191 Times in 177 Posts
    Which part are you unable to accomplish?
    Regards,
    Rory

    Microsoft MVP - Excel

  5. #5
    3 Star Lounger
    Join Date
    Jun 2005
    Posts
    387
    Thanks
    3
    Thanked 0 Times in 0 Posts
    I can protect sections of the worksheet however I cannot utilize the filters when protection is on.

    As an aside, how can I attach a sample work sheet to demonstrate?

  6. #6
    WS Lounge VIP rory's Avatar
    Join Date
    Dec 2000
    Location
    Burwash, East Sussex, United Kingdom
    Posts
    6,280
    Thanks
    3
    Thanked 191 Times in 177 Posts
    Did you set up the autofilter before you protected the sheet and did you check the option to allow filters when protecting it?

    To attach a workbook, click the Go Advanced button, then use the Manage attachments option.
    Regards,
    Rory

    Microsoft MVP - Excel

  7. #7
    WS Lounge VIP
    Join Date
    Mar 2002
    Location
    Newcazzle, UK
    Posts
    2,826
    Thanks
    136
    Thanked 482 Times in 459 Posts
    Hi MNN

    As Rory says, in Excel2007, to do what you want:
    1. Protect sections of sheet as required, then..
    2. Turn Autofilters on where you need them (in the top panel Ribbon, select Data group tab,then Filter), then..
    3. From the top panel Ribbon, delect the Review group tab, and then select Protect Sheet
    4. In the Protect sheet dialog box that is shown, scroll down and check the box that says Use Autofilter.

    You have to do this in the sequence above.

    zeddy

  8. #8
    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
    Isn't this the same question you asked in http://windowssecrets.com/forums/sho...of-a-worksheet

    Steve

  9. #9
    3 Star Lounger
    Join Date
    Jun 2005
    Posts
    387
    Thanks
    3
    Thanked 0 Times in 0 Posts
    Thank you. It worked great.



    Yes Steve, When I went to review I could not find it and that's why I duplicated the question.

Posting Permissions

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