Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Hiding print dialog box within macro
Please could anyone tell me if there is a way of stopping
the Cancel Print Dialog Box from being displayed within a macro which automates the process of printing several individual pages of different ranges of cells. The macro incorporates un-hiding a row prior to printing and re- hiding the row after printing, and I would like to prevent the user from stopping the macro before completion to ensure the worksheet returns back to its original state. I would be grateful for any suggestions. Many thanks in advance, Annie |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Print Dialog Box | Excel Worksheet Functions | |||
Print Dialog box | Excel Discussion (Misc queries) | |||
Print dialog box selection macro | Excel Discussion (Misc queries) | |||
Hiding the 'printing' dialog box | Excel Discussion (Misc queries) | |||
get information from Print dialog | Excel Programming |