View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
David David is offline
external usenet poster
 
Posts: 195
Default Want row to stay hidden

I run the following macro to fax a ride list:

Sub FaxIt()
Dim CurPrinter As String
Range("Names").AutoFilter Field:=1, Criteria1:="<"
CurPrinter = Application.ActivePrinter
ActiveWorkbook.PrintOut , ActivePrinter:="Brother PC-FAX on BMFC:"
Range("Names").AutoFilter
Application.ActivePrinter = CurPrinter
End Sub

There are times when I want to exclude a rider or two temporarily by hiding
its row prior to faxing. I do this manually with Format | Row | Hide, but
the macro unhides it.

How can I make my chosen row(s) stay hidden?

--
David