Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
1) When I protect a sheet, I can no longer use the grouping boxes
2) I would like to be able to keep users from moving the text boxes and still protect the sheet. |
#2
![]() |
|||
|
|||
![]()
Does Grouping mean outlining (like from Data|Group or Data|subtotal)???
If yes: If you already have the outline 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 Smokey Mike wrote: 1) When I protect a sheet, I can no longer use the grouping boxes 2) I would like to be able to keep users from moving the text boxes and still protect the sheet. -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
Excel on XP: Password Protection | Excel Discussion (Misc queries) | |||
Difference in number of Excel NewsGroups | Excel Discussion (Misc queries) | |||
protection on excel forms | Excel Worksheet Functions | |||
Protection in Excel via email | Excel Worksheet Functions |