Check your other thread.

Chuck wrote:

hi guys,

first, sorry for the multiple posts (but thought this group would be
more relevant for my needs)

query:

is there a way i can put a button within the first sheet of my
workbook that says.. print workbook

when doing so, it will print the following tabs (as i have more then
the specific tabs mentioned below)

notes
actual
spend calendar
purchase record

and within this function, look at tabs 001-013 and identify if there
is any value in $J$38 0 in each tab, if so, print the tabs that have
a value 0

cheers
chuck

--

Dave Peterson