Print Preview and Print
 

I have a macro, and I need to show the operator a spreadsheet that may have
90 lines on it (long enough to force scrolling to see all of it), and not
allow printing of the spreadsheet. I can do a dialog print preview, but that
allows print. If I use "Before print" macro to cancel print, they can't use
printpreview either. I don't want to give control to the operator. I have
tried printing to a file, but the operator must specify file location
and name. That would give the operator control. (I don't seem to be able to
set the file name within the dialog box)

Your help is greatly appreciated.