Results 1 to 1 of 1
2001-02-09, 08:33 #1
- Join Date
- Dec 2000
- Thanked 0 Times in 0 Posts
"FillAcrossSheets" vs "userInterfaceOnly"
This is the same Excel 97 question I have posted in www.experts-exchange.com (where are the tags gone ?). Perhaps I am luckier here:
Did you ever have the situation that you needed to have the Outlining (or the Autofilter) operational on an protected worksheet and, at the same time, having to use the FillAcrossSheets method because of speed ? Well, it seems that I have stumbled over something which has no reference in the MSKB nor in the internet:
The second Sub simply wipes out the worksheet protection applied by the first one.
.EnableOutlining = True
.Protect contents:=True, DrawingObjects:=True, userInterfaceOnly:=True
Dim x As Variant
x = Array("Sheet1", "Sheet2", "Sheet3")
a) Do I miss something ?
Is there any other solution than to call the EnableGrouping again after using the FillAcrossSheets