Results 1 to 3 of 3
  1. #1
    Lounger
    Join Date
    Apr 2001
    Location
    Ames, Iowa, USA
    Posts
    34
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Subtotals & Worksheet Protection (Excel 2000)

    HI!

    Small conundrum here...

    Need to Lock certain cells on a worksheet and make others open for entry... no big deal... unlock/protect sheet... cool

    Problem is I need the worksheet to also be able to expand and collaspe subtotals. You can't do that on a protected sheet. Wow... never run accross that before!

    Any brilliant ideas?

    Thanks!

    JC<img src=/S/smile.gif border=0 alt=smile width=15 height=15> <img src=/S/basket.gif border=0 alt=basket width=58 height=52>
    (tanking big time in NCAA pool!!!)

  2. #2
    Silver Lounger
    Join Date
    Mar 2001
    Location
    Springfield, Ohio, USA
    Posts
    2,136
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Subtotals & Worksheet Protection (Excel 2000)

    I don't think that this can be done without code. It can be done with code, you will need to set EnableOutlining true in the Workbook_Open event. HTH --Sam
    <font face="Comic Sans MS">Sam Barrett, CACI </font face=comic>
    <small>And the things that you have heard... commit these to faithful men who will be able to teach others also. 2 Timothy 2:2</small>

  3. #3
    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: Subtotals & Worksheet Protection (Excel 2000)

    In addition to setting enableoutlining to true, you must also protect the worksheet with userinterfaceonly = true

    It is analogous to using autofilter with protection as discussed in the thread starting in <post#=340494>post 340494</post#>

    The coding is similar, just use enableoutlining instead of enable autofilter. The subtotals must be added while the workbook is unprotected, then enable outlining, then protect with userinterfaceonly.

    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
  •