Posted to microsoft.public.excel.programming
|
|
Grouping and outline
Chip Pearson has instructions for adding procedures through code:
http://www.cpearson.com/excel/vbe.htm
swami wrote:
HI ,
thanks for the reply.
But as i already mentioned , i am generating about 100 workbook and assign
formulas . all my workbooks are automatically created by macros. Now how to
assign the below code to each and every work book. Any idea
thanks
"Debra Dalgleish" wrote:
If you protect the worksheet programmatically, you can enable outlining,
and you will be able to use the groups that you have created.
The following code goes in the ThisWorkbook module:
Private Sub Workbook_Open()
With Worksheets("Sheet1")
.EnableOutlining = True
.Protect Password:="password", _
Contents:=True, UserInterfaceOnly:=True
End With
End Sub
To paste the code into the ThisWorkbook module:
Right-click on the Excel icon, to the left of the File menu
Choose View Code
Paste the code where the cursor is flashing.
swami wrote:
Hi,
I need to operate the outline symbols ( +OR - , when the data grouping is
done) in a protected mode. At present Excel does not allows it . Any idea. My
excel sheet is being created by a macro and assigns all the formulas,
datagrouping . When i run from macro and check it is working. Once i save the
file and reopen it i am getting problem.
--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html
--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html
|