Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Group Controls
Hi...
An easy one for someone... In a protected sheet how can I enable grouping controls and auto filters simoultaneously... Thanks in advance... JD |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Group Controls
sub Auto_Open()
with worksheets("sheet1") .activate .EnableAutoFilter = True .EnableOutlining = True .Protect UserInterfaceOnly:=True end with End Sub I think Tom Ogilvy has posted some notes about protection failing and one fix was to active the worksheet first. But excel doesn't remember this after you close the workbook. It has to be rerun when you open the workbook. So you can use auto_open or workbook_open Jack D wrote: Hi... An easy one for someone... In a protected sheet how can I enable grouping controls and auto filters simoultaneously... Thanks in advance... JD -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Taking age group Ie ages 20-29 and picking out net sales for group | Excel Worksheet Functions | |||
ActiveX Controls vs Form Controls | Excel Discussion (Misc queries) | |||
Is it possible to group parts with controls? | Excel Discussion (Misc queries) | |||
How do I group worksheets (Lotus 123 function is "Sheet>Group Shee | Excel Worksheet Functions | |||
group name for form controls | Excel Programming |