Hi!

I'm using this commands in VBA (Excel 2000):

Sub Auto_Open()
With Worksheets("Sheet1")
.Protect Password:="pass", userinterfaceonly:=True
.EnableAutoFilter = True
End With

End Sub


....to use autofilter when the sheet1 is protected. I also created th
same VBA commands to do the same in sheet2:

Sub Auto_Open()
With Worksheets("Sheet2")
.Protect Password:="pass", userinterfaceonly:=True
.EnableAutoFilter = True
End With

End Sub


It works fine until I close and reopen this workbook. Then there is a
error message "Ambiguous name detected: Auto_Open"

It works fine with only sheet1 protected, but not with two or more??

What can be the problem

-----------------------------------------------
~~ Message posted from http://www.ExcelTip.com
~~View and post usenet messages directly from http://www.ExcelForum.com