Allowing access to 'grouped rows' whilst worksheet protected

  • Thread starter Thread starter Stuart
  • Start date Start date
S

Stuart

Hi all,

I have a worksheet with data that I need to protect but also have a number
of row and column groups I'd like the user to be able to reveal/access. If
I protect the worksheet and allow access to unlocked cells, the User can't
access the 'group' buttons to reveal rows or columns.

It's probably simple but can anyone tell me a box to check that enables
access whilst keeping the data secure?

Thanks in advance . . . Stuart
 
If you already have the outline applied, you can protect the worksheet in code
(auto_open/workbook_open??).

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

It needs to be reset each time you open the workbook. (excel doesn't remember
it after closing the workbook.)

(you could use the workbook_open even under ThisWorkbook, too.)

Don't forget to lock the VBA Project, too. Else you'll have inquisitive types
looking at your code and seeing the password.

Inside the VBE, you can lock the project.
Tools|VBAProject Properties|Protection tab.
Give it a memorable password and lock the project for viewing.

If you're new to macros, you may want to read David McRitchie's intro at:
http://www.mvps.org/dmcritchie/excel/getstarted.htm
 
Back
Top