![]() |
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