Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Protection using the subtotal function
Is it possible to protect a worksheet and still be able to use the subtotal
(grouping and ungrouping) function in excel? I need to protect a document but be able to allow others to group/ungroup the data. Can this be done? Thanks, -- Scottm |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Protection using the subtotal function
Yes, it is possible with VBA. Copy the following code into a VBA module in
the workbook. Edit the sheet name ("Sheet1") and password ("hi") as appropriate. Option Explicit Sub Auto_Open() With Worksheets("Sheet1") .Protect Password:="hi", UserInterfaceOnly:=True .EnableSelection = xlNoSelection .EnableOutlining = True .EnableAutoFilter = True End With End Sub Hope this helps, Hutch "Scottm" wrote: Is it possible to protect a worksheet and still be able to use the subtotal (grouping and ungrouping) function in excel? I need to protect a document but be able to allow others to group/ungroup the data. Can this be done? Thanks, -- Scottm |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
COUNTIF Subtotal Function? | Excel Discussion (Misc queries) | |||
Cannot Reference "Array" in Subtotal Function | Excel Worksheet Functions | |||
Nested --- Subtotal IF function | Excel Worksheet Functions | |||
Subtotal function with Filtered Data | Excel Discussion (Misc queries) | |||
clock | Excel Worksheet Functions |