Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Protect woksheet and keep using outline capabilities
Hello,
I need to share a worksheet and protect certain cells (preventing users to replace formulas by values) I tried to lock these cells and protect the worksheet. Problem : when I do so, users can no longer use ouline "+" and "-" icons to show or hide columns. Could somebody help me ? I am using Excel 2003 Many thanks and kind regards -- Jean-Luc |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Protect woksheet and keep using outline capabilities
If you already have the outline/subtotals/autofilter 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 '.EnableAutoFilter = True 'If .FilterMode Then ' .ShowAllData 'End If End With End Sub It needs to be reset each time you open the workbook. (Earlier versions of excel don't remember it after closing the workbook. IIRC, xl2002+ will remember the allow autofilter setting under tools|Protection|protect sheet, but that won't help when you're filtering via code.) Jean-Luc wrote: Hello, I need to share a worksheet and protect certain cells (preventing users to replace formulas by values) I tried to lock these cells and protect the worksheet. Problem : when I do so, users can no longer use ouline "+" and "-" icons to show or hide columns. Could somebody help me ? I am using Excel 2003 Many thanks and kind regards -- Jean-Luc -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
protect the worksheet but still can do the "group and outline" dat | Excel Discussion (Misc queries) | |||
Protect worksheet but expand and collapse outline? | Excel Discussion (Misc queries) | |||
Can I protect an Excel spreadsheet, and use Outline functions? | Excel Worksheet Functions | |||
how to protect excel worksheet and still use the outline buttons? | Excel Worksheet Functions | |||
Protect sheet with outline | Excel Worksheet Functions |