I currently use the following code to ask user if they wish
to print pages that have been previously totalled as '0.00'.

'Ask user if they want to print zero pages
Msg = "Do you want to print pages that total 0.00" & _
vbNewLine & _
"in the worksheet: " & ActiveSheet.Name & " ?"
Style = vbYesNo + vbDefaultButton2
Title = ActiveWorkbook.Name
Response = MsgBox(Msg, Style, Title)
If Response = vbYes Then
PrintZeroPages = True
Else '''probably redundant since DefaultButton2 ?
PrintZeroPages = False
End If

A later test on 'PrintZeroPages' will decide whether to
exclude a particular range from the print routine, or not.

However, if the sheet has NOT been previously
calculated, then the particular cells in question will not
hold '0.00'......they will be Empty, and therefore these
empty ranges will also print.

What I'd like to ask user is:

i) Do you want to skip pages totalling '0.00'
ii) Do you want to skip pages where the total is Empty
iii) Do you want to skip both '0.00' and Empty

How can I best construct this, please?

Regards


How best to achieve the following, please:?

Regards.


---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.505 / Virus Database: 302 - Release Date: 30/07/2003