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

    Unprotecting certain areas of a worksheet

    How do you unprotect certain areas ( non contiguous ares) of a worksheet so those area can be written on? Also, Can you unprotect the titles and use the FILTER?

    i want to protect and hide the fomulas in the worksheet located from column k thru column o and the columns a - j are downloaded data.

    Thanks.

  2. #2
    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
    You con unprotect cells in the worksheet when the worksheet is unprotected. It is under Format-cells dialog, protection tab. By default all cells are "Locked" but not "Hidden". Neither has any affect until the worksheet is protected. When protected, any cell that is locked can not be edited and any cell that is hidden will not display in the formula bar. So to allow editing in cells, unlock the cells of interest. To prevent display of formulas check "hidden" for those cells. Then protect the worksheet.

    You don't need to unprotect the titles to allow autofilter. To allow autofilter when protected, after selecting "Protect workbook" make sure that the "Use Autofilter" is checked.

    Steve

  3. #3
    3 Star Lounger
    Join Date
    Jun 2005
    Posts
    386
    Thanks
    3
    Thanked 0 Times in 0 Posts
    Thanks steve. Sorry for the duplication

Posting Permissions

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