Re: AutoMacro to change cell formats on printing

: Dave,
Thanks for the help on placing the Beforeprint event in this workbook module.That works great. I have written code designed to reformat a range and then I want it to print and following printing I want to change the format back to its default.All so that the user needs only to highlight the range and press file\print. The trick I am looking for is how to accomplish this with one subroutine initially autoactivated by file\print so that printing is carried out before the format goes back to default. I really enjoy your website. Thanks so much.