ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Hiding print dialog box within macro (https://www.excelbanter.com/excel-programming/275156-hiding-print-dialog-box-within-macro.html)

Annie[_2_]

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



All times are GMT +1. The time now is 12:21 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com