+ Reply to Thread
Results 1 to 1 of 1

[SOLVED] Protecting sheet with grouped columns

Hybrid View

DanteeChaos [SOLVED] Protecting sheet... 07-24-2015, 03:49 AM
  1. #1
    Registered User
    Join Date
    07-24-2015
    Location
    Poland
    MS-Off Ver
    2010
    Posts
    1

    [SOLVED] Protecting sheet with grouped columns

    Hello.
    I'm in a pickle with my current project. I need to protect a part of a sheet which contains grouped columns. The problem is that when the sheet is protected whenever I click on the + or - the columns don't expand or retract http://imgur.com/0r9mtTM (excel probably counts this as editing). Does anyone know a way around this? Also, please try it out before posting anything - I have tried several protection options and all of them didn't work as I wanted.



    EDIT - EDIT - EDIT - EDIT - EDIT - EDIT - EDIT - EDIT - EDIT - EDIT - EDIT - EDIT

    The soultion is here ----> http://www.mrexcel.com/forum/excel-q...orksheets.html
    Last edited by DanteeChaos; 07-24-2015 at 04:31 AM. Reason: SOLVED

+ 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. Replies: 2
    Last Post: 01-10-2014, 09:30 PM
  2. Grouped rows disabled when Protecting worksheets!
    By DaveRimmer in forum Excel General
    Replies: 9
    Last Post: 11-27-2013, 12:18 AM
  3. Protecting columns in a sheet
    By Cmorgan in forum Excel - New Users/Basics
    Replies: 6
    Last Post: 02-21-2011, 07:57 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
  6. Locking columns and not protecting whole sheet
    By changetires in forum Excel General
    Replies: 3
    Last Post: 07-13-2006, 12:50 PM
  7. Sheet Protection & Grouped Columns in Excel
    By Ruth Betts in forum Excel General
    Replies: 2
    Last Post: 04-29-2005, 06:06 PM

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