How do I apply Personal.xls to existing workbooks?
Posted on 2009-04-07
I need to know how to write a Before_Print macro that will apply to all existing workbooks on my machine when I open them.
I have a folder of over 100 excel files that I need to open, print entire workbook, and close. I have stored the macro to select all sheets in the Before_Print Sub in Personal.xls, but when I open other workbooks, all the sheets are not selected when I print.