How do I protect sheet, but allow "group" function to work
Hello, I have a spreadsheet with multiple sheets, and want to prevent people from seeing my formulas by protected the sheets. However, I have data "grouped." If I protect the sheet, people can't click on the "+" to expand groupings. How do I accomplish both? David -- dwsmha ------------------------------------------------------------------------ dwsmha's Profile: http://www.excelforum.com/member.php...o&userid=26764 View this thread: http://www.excelforum.com/showthread...hreadid=400174 |
If you already have the outlining 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.) If you're new to macros, you may want to read David McRitchie's intro at: http://www.mvps.org/dmcritchie/excel/getstarted.htm dwsmha wrote: Hello, I have a spreadsheet with multiple sheets, and want to prevent people from seeing my formulas by protected the sheets. However, I have data "grouped." If I protect the sheet, people can't click on the "+" to expand groupings. How do I accomplish both? David -- dwsmha ------------------------------------------------------------------------ dwsmha's Profile: http://www.excelforum.com/member.php...o&userid=26764 View this thread: http://www.excelforum.com/showthread...hreadid=400174 -- Dave Peterson |
All times are GMT +1. The time now is 12:36 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com