ungroup rows when a workbook protected

Microsoft Excel 2003 (full product)
February 9, 2011 at 23:43:33
Specs: Windows XP
I have written the following macro to run when I open my workbook however i want to assign it to multiple sheets and at the moment i can only assign to one. Macro below:

Private Sub Workbook_Open()
With Worksheets("sum")
.EnableOutlining = True
.Protect Password:="password", _
Contents:=True, UserInterfaceOnly:=True
End With
End Sub

See More: ungroup rows when a workbook protected

February 10, 2011 at 13:25:01
re: "assign it to multiple sheets"

Please be a little more specific.

Does "multiple sheets" mean all of the sheets in the workbook or specific sheets by name or specific sheets by location in the workbook or something else?

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

Report •

February 13, 2011 at 23:52:27
I am trying assign the macro to all the worksheets in that particular workbook, i have four other sheets i want to assign the macro to these are called, Wood, Syn, Line marking and costing. Any advice would help loads


Report •
Related Solutions

Ask Question