Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
seperate print and printview
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how do I print seperate excel tab sheets in duplex | Excel Discussion (Misc queries) | |||
Macro printview | Excel Programming | |||
Macro printview | Excel Programming | |||
Print data in each row on a seperate sheet template | Excel Discussion (Misc queries) | |||
Print all data from list on seperate form | Excel Programming |