Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I open or close grouped columns/rows in a protected excel s
How can I open or close grouped columns/rows in a protected excel sheet ?
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I open or close grouped columns/rows in a protected excel s
Try copying the sheet (or columns) into a new workbook. -- mdbct ------------------------------------------------------------------------ mdbct's Profile: http://www.excelforum.com/member.php...o&userid=28733 View this thread: http://www.excelforum.com/showthread...hreadid=494412 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I open or close grouped columns/rows in a protected excel s
Unprotect the sheet.
An alternative is to protect the sheet in code and give it a special instruction that allows either autofiltering or outlining to work on a protected sheet. 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 .EnableAutoFilter = 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 Haranath wrote: How can I open or close grouped columns/rows in a protected excel sheet ? -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I open a Quattro Pro 7.0 file in Excel 2003 | Excel Discussion (Misc queries) | |||
Can't open files from outside Excel | Excel Discussion (Misc queries) | |||
Excel startup switches | Excel Discussion (Misc queries) | |||
How Do I open an excel file without Excel Viewer support | Excel Discussion (Misc queries) | |||
Unable to open excel sheet in Protected mode from VB 6.0 | Setting up and Configuration of Excel |