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 could then specify file location
and name. (I don't seem to be able to set the file name within the dialog box)

Your help is greatly appreciated.