+ Reply to Thread
Results 1 to 3 of 3

Allow access to show/hide detail of grouped cells on protected sheet

Hybrid View

Danaki Allow access to show/hide... 11-03-2007, 12:59 PM
VBA Noob Does this link help ... 11-03-2007, 01:22 PM
Danaki Thank You 11-04-2007, 01:07 AM
  1. #1
    Registered User
    Join Date
    11-03-2007
    Posts
    2

    Allow access to show/hide detail of grouped cells on protected sheet

    Anyone smarter than me,
    I have been asked to create an excel file that can keep track of a lot of information concerning training excercises for the employees of the company. As there are many different sections and many requirements inside those sections, I thought I would make it easier on the person that had to edit the sheet by grouping the requirements in each section together so you could show/hide sections and make the sheet smaller to elimate the need to scroll up and down the huge document. Anyway, I was able to do that fine, now the problem I am facing is that now, I need to protect the sheet and workbook so that no one accidentally changes any of my formulas or requirements. However, when I protect the sheet, all users are now unable to show/hide details of the groups. I have tried various different permissions and things and haven't had any luck. Anyone have any good ideas or references that I can look at?
    Thanks,
    Danaki

  2. #2
    Forum Contributor VBA Noob's Avatar
    Join Date
    04-25-2006
    Location
    London, England
    MS-Off Ver
    xl03 & xl 07(Jan 09)
    Posts
    11,988
    Does this link help

    http://www.ozgrid.com/Excel/outlining-protected.htm

    VBA Noob
    _________________________________________


    Credo Elvem ipsum etian vivere
    _________________________________________
    A message for cross posters

    Please remember to wrap code.

    Forum Rules

    Please add to your signature if you found this link helpful. Excel links !!!

  3. #3
    Registered User
    Join Date
    11-03-2007
    Posts
    2

    Thank You

    Yes, I think that might help. it seems pretty straight forward. Now if only Microsoft hadn't gone and changed the whole interface of 2007 I could find how to view the code a lot quicker. :P I appreciate the help. I assume I can add this code to the top of the code in any excel worksheet? Correct?

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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