Neale Blackwood reduces some macro mayhem.
Q. I have recorded a macro to print my sheets. I need to print some sheets single-sided and others double-sided. The macro won't record the change between single and double-sided. Is it possible to create a macro to do this?
A. Macros don't have many limitations, but changing printer settings is one of them. The solution is to set up two printers on your system. One has single-sided as the default and the other has double-sided (duplex). When you record the macro, simply select your sheet and change printers and print, and then select another sheet and another printer and print. The macro recorder will record changes in the printers selected.
Neale Blackwood CPA is a senior business analyst with Access Analytic Solutions, which provides financial modelling and management reporting services, as well as advanced Excel training.
Further information
Reference: April 2008, volume 78:03, p. 19
