| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Hide / Unhide columns for Printing
I would like to create a script that would execute previous to printing that
would hide any row that the value in the Cell E is "Not Started". I am saving a value in E that will delineate whether a job is started / in progress / or complete. One of the reports to print is any job that is not started yet. Therefore I want only the rows with "Not Started" in E to print. Then, I want the rows unhidden when printing is complete. There are 125 rows with data. A: Job B: Assigned Personnel C: Department D: Contact E: Status How could I achieve this? -- Thanks As Always Rip |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Hide/Unhide rows for printing | Excel Discussion (Misc queries) | |||
| Automatically hide/unhide columns | Excel Discussion (Misc queries) | |||
| Auto hide/Unhide columns | Excel Worksheet Functions | |||
| Hide/Unhide columns using button on top over relevant columns | Excel Discussion (Misc queries) | |||
| Unhide and hide columns | Excel Worksheet Functions | |||
Threaded Mode
