Try setting the print area. Some people use a Before_Print event to make sure
the proper range is set.

"Wescotte" wrote:

I'm looking to display the print dialog and only return true if the
user clicked OK
so I have the following. The function below works but I'd also like to
force them to print the entire worksheet and not have any other optiosn
but selecting the printer to use. I've looked up the various arguements
for .Show but I can't see to get any to work. I've tried .Show
argname:= value but that didn't work.. I'm not sure what I'm doing
wrong

Function PrintSheet()

dlgAnswer = Excel.Application.Dialogs(xlDialogPrint).Show
If dlgAnser < -1 Then
PrintSheet = false
else
PrintSheet = True
End If
Exit Function