need help "worksheet_activate( )"

G

Guest

i need help using the autofilter function in my worksheet activate event
procedure
i'm using these parameters below:

Private Sub worksheet_activate()
Range("A1:C1").AutoFilter 2, "<>", , , False
End Sub

i want the worksheet to autofilter automatically when i select the sheet.
i'm still getting errors i need help. can anyone help me with these codes??

thanks in Advance
--
 
G

Guest

Hi Ernie,

Try:

Private Sub worksheet_activate()
Range("A1:C1").AutoFilter Field:=2, Criteria1:="<>", VisibleDropDown:=False
End Sub

This worked fine for me.

HTH
DS
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Problem with Worksheet_Activate event 3
Very Slow Worksheet Calculation 4
Need to prevent call Sub Worksheet_Activate() during macro. 3
Select method of range class failed problem 2
XL2002 - Worksheet_Activate Question... 3
Help me4 2
Excel Code to run ActiveWindow.View in normal view, only runs manually. 21
Progmatically add code to worksheet_activate 3

Top