Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Some comments stay hidden even after picking show/hide all why? | Excel Discussion (Misc queries) | |||
2007 Worksheet, Hidden Columns, .CSV Format Saves Hidden Column Da | Excel Discussion (Misc queries) | |||
Hidden rows columns won't stay hidden | Excel Worksheet Functions | |||
I need my Hidden Rows to stay hidden when I print the sheet. | Excel Discussion (Misc queries) | |||
Ex 2K Standard Toolbar won't stay hidden | Excel Discussion (Misc queries) |