Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Userinterfaceonly
i have the following code to allow users to Group and Ungroup and delete
columns in a protected worksheet. can someone tell me what i'm doing wrong. i got it working with grouping/ungrouping, but when i tried to add the ability to delete columns it stopped working. p.s. this is my first time using userinterfaceonly...is there something risky about it or just a work-around because excel's protected worksheets are so restrictive in what they allow a user to do? thanks in advance for any and all advice, tami Private Sub Workbook_Open() With Worksheets("Ladders") .EnableOutlining = True .Protect AllowDeletingColumns:=True, Password:="paspas", _ userinterfaceonly:=True End With End Sub |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
UserInterfaceOnly & Password Protection | Excel Discussion (Misc queries) | |||
UserInterfaceOnly | Excel Discussion (Misc queries) |