Consulting

Results 1 to 5 of 5

Thread: Enable use of "Grouping" with Excel 2000

  1. 09-04-2005, 12:52 PM #1
    malik641
    malik641 is offline
    Administrator
    2nd VP-Knowledge Base     VBAX Master malik641's Avatar
    Joined
    Jul 2005
    Location
    Florida baby!
    Posts
    1,533
    Location

    Enable use of "Grouping" with Excel 2000

    When a sheet is protected with grouped cells in Excel 2000, the user is unable to Expand and Collapse the Grouped cells. How can I enable that with a protected sheet on Excel 2000????




    New to the forum? Check out our Introductions section to get to know some of the members here. Feel free to tell us a little about yourself as well.
    Reply With Quote Reply With Quote
  2. 09-05-2005, 06:32 PM #2
    malik641
    malik641 is offline
    Administrator
    2nd VP-Knowledge Base VBAX Master malik641's Avatar
    Joined
    Jul 2005
    Location
    Florida baby!
    Posts
    1,533
    Location
    I also noticed that this is the same for 2003.

    Can anyone help me!?!?!




    New to the forum? Check out our Introductions section to get to know some of the members here. Feel free to tell us a little about yourself as well.
    Reply With Quote Reply With Quote
  3. 09-05-2005, 07:19 PM #3
    austenr
    austenr is offline
    Moderator VBAX Master austenr's Avatar
    Joined
    Sep 2004
    Location
    Maine
    Posts
    2,033
    Location
    Try unlocking the cells before you protect the sheet.
    Peace of mind is found in some of the strangest places.
    Reply With Quote Reply With Quote
  4. 09-05-2005, 07:35 PM #4
    malik641
    malik641 is offline
    Administrator
    2nd VP-Knowledge Base VBAX Master malik641's Avatar
    Joined
    Jul 2005
    Location
    Florida baby!
    Posts
    1,533
    Location
    No good....




    New to the forum? Check out our Introductions section to get to know some of the members here. Feel free to tell us a little about yourself as well.
    Reply With Quote Reply With Quote
  5. 09-06-2005, 04:47 AM #5
    malik641
    malik641 is offline
    Administrator
    2nd VP-Knowledge Base VBAX Master malik641's Avatar
    Joined
    Jul 2005
    Location
    Florida baby!
    Posts
    1,533
    Location
    Got it. Thanks to Dave Peterson, the code is:


    Option Explicit
Private Sub Workbook_Open()
With Worksheets("sheet1")
.Protect Password:="hi", userinterfaceonly:=True
.EnableOutlining = True
End With
End Sub
    Awesome




    New to the forum? Check out our Introductions section to get to know some of the members here. Feel free to tell us a little about yourself as well.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules