+ Reply to Thread
Results 1 to 10 of 10

Grouped rows disabled when Protecting worksheets!

Hybrid View

  1. #1
    Forum Expert
    Join Date
    04-22-2013
    Location
    .
    MS-Off Ver
    .
    Posts
    4,418

    Re: Grouped rows disabled when Protecting worksheets!

    Wade,

    PRess alt+F11 to open the vba editor. click insert->module and then in that module paste the code. Finally place the cursor between the sub and end sub commands and press F5 to apply.

  2. #2
    Registered User
    Join Date
    05-22-2012
    Location
    Minnesota
    MS-Off Ver
    Excel 2010
    Posts
    7

    Re: Grouped rows disabled when Protecting worksheets!

    Thank you! This worked great!

    Wade

  3. #3
    Registered User
    Join Date
    05-22-2012
    Location
    Minnesota
    MS-Off Ver
    Excel 2010
    Posts
    7

    Re: Grouped rows disabled when Protecting worksheets!

    yudlugar,

    I successfully added the VBA code and it worked; I could expand and collapse the group while the sheet was protected. However, when I saved (using macro-enabled workbook) and closed the file, upon opening the file, it would not let me expand or collapse the group. It seems the code didn't get saved. Please help...one more time.

    Wade

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Creating Grouped Worksheets
    By Janie in forum Excel General
    Replies: 2
    Last Post: 07-18-2013, 09:05 AM
  2. Replies: 0
    Last Post: 06-18-2012, 12:05 PM
  3. Replies: 7
    Last Post: 06-17-2012, 02:24 PM
  4. Protecting grouped columns
    By BrookHollis in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 08-09-2007, 02:37 PM
  5. Protecting Workbook when Sheets are Grouped
    By Jere Mayfield in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 06-07-2007, 11:12 AM

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