D DanSpenc Jul 23, 2004 #1 I'm trying to find a way to allow a user to expand grouped cells on protected sheet without first having to unprotected it
I'm trying to find a way to allow a user to expand grouped cells on protected sheet without first having to unprotected it
R Ron de Bruin Jul 23, 2004 #2 Hi Read this from Dave Peterson If you protect the worksheet with code, you can do more things: Add this to a general module: 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.) If you're new to macros, you may want to read David McRitchie's intro at: http://www.mvps.org/dmcritchie/excel/getstarted.htm
Hi Read this from Dave Peterson If you protect the worksheet with code, you can do more things: Add this to a general module: 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.) If you're new to macros, you may want to read David McRitchie's intro at: http://www.mvps.org/dmcritchie/excel/getstarted.htm
