+ Reply to Thread
Results 1 to 3 of 3

Grouping and ungrouping in protected workbook

  1. #1
    Registered User
    Join Date
    06-15-2010
    Location
    michigan
    MS-Off Ver
    Excel 2013
    Posts
    31

    Grouping and ungrouping in protected workbook

    Hello All: Using Excel 2013 I have a workbook of several pages that I am protecting to eliminate any alterations to structure and limit access to locked cells. I have one page of workbook that I need to allow for users to expand and collapse rows of data that I have grouped.
    I need a way of allowing for users to expand and collapse these rows by simply selecting the +/- keys on left once I've protected workbook. What I also need is to keep the structure and locked cells from being changed or accessed once the rows are expanded or collapsed.
    If I need to accomplish this through VBA, please go slowly as my experience is minimal at best.

    The whole intention is to allow some users the ability to have additional rows to enter data, yet for those that don't need the additional data entry, minimize the size of the document. If there is a better way to accomplish this rather than through " group - ungroup" please share with me.

    Thank you all for your help.

  2. #2
    Forum Guru
    Join Date
    08-05-2004
    Location
    NJ
    MS-Off Ver
    365
    Posts
    13,582

    Re: Grouping and ungrouping in protected workbook

    What protection options are you using: "Protect Sheet" and "Protect Workbook"?

    This code will work but it has your password embedded in it. (An alternative is to put the password in a hidden worksheet and then have the code reference that cell)
    Place this code in the worksheet (Right click on the tab>View Code and paste this code into the VBA editor)
    Please Login or Register  to view this content.
    Does that do what you wanted it to do?
    ChemistB
    My 2?

    substitute commas with semi-colons if your region settings requires
    Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
    If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)

    Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble

  3. #3
    Registered User
    Join Date
    06-15-2010
    Location
    michigan
    MS-Off Ver
    Excel 2013
    Posts
    31

    Re: Grouping and ungrouping in protected workbook

    ChemistB: Thank you for your response. I have since decided to expand rows using checkboxes instead of using +/- tabs. May have to resubmit question to reflect new approach .

    Thanks again.

+ 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] VBA code to allow grouping/ungrouping in protected excel worksheet
    By SherryAnneMay in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 07-22-2015, 04:58 AM
  2. [SOLVED] Grouping and Ungrouping Checkboxes
    By sreerajmp in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-10-2013, 06:24 AM
  3. Grouping/Ungrouping columns with the sheet protected?
    By Shishek in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-10-2013, 01:47 PM
  4. protected sheet to allow grouping/ungrouping
    By jw01 in forum Excel General
    Replies: 0
    Last Post: 01-09-2013, 11:26 AM
  5. Grouping/Ungrouping protected sheets with VBA
    By Stormdronk in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 09-10-2011, 02:12 AM
  6. Grouping & Ungrouping rows with 'protection' on
    By pfrattali in forum Excel General
    Replies: 2
    Last Post: 09-30-2008, 01:51 AM
  7. Grouping / Ungrouping
    By bluebadger in forum Excel General
    Replies: 1
    Last Post: 04-27-2006, 11:45 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