Thread: Disabling and re-enabling the AutoFilter from VBA
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Leith Ross[_55_] Leith Ross[_55_] is offline
external usenet poster
  
Posts: 1
Default Disabling and re-enabling the AutoFilter from VBA

Hello CFD,

Each Worksheetsheet has an AutoFilter property. This is a read/write
(toggle) property. Try this...

Worksheets("Sheet1").EnableAutoFilter = False (Turn it off)
Worksheets("Sheet1").EnableAutoFilter = True (Turn it on)

Substitute the sheet you are working with for Sheet1 in the examples.

Sincerely,
Leith Ross


--
Leith Ross
------------------------------------------------------------------------
Leith Ross's Profile: http://www.excelforum.com/member.php...o&userid=18465
View this thread: http://www.excelforum.com/showthread...hreadid=476079

Reply With QuoteReply With Quote