View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Ripper Ripper is offline
external usenet poster
 
Posts: 25
Default 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