A
Annie
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
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