![]() |
error '438'
I have the error '438' - Object doesn't support this property or method.
Private Sub Worksheet_Activate() ' It's Sheet1 .... With Worksheets("Sheet1") If Not .AutoFilterMode Then .Range("A3").AutoFilter End If .EnableAutoFilter = True .Protect Password:="password", _ Contents:=True, UserInterfaceOnly:=True End With Selection.AutoFilter Field:=1 ' Here I have an error .... Can anybody advise what's wrong with this code? Thanks |
All times are GMT +1. The time now is 12:52 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com