How to set Excel’s ActivePrinter using VBA?

Changing Excel’s ActivePrinter using VBA isn’t as straightforward as you might think. In particular there is a localization issue.

Disable Shift key on open

A user can prevent the Workbook_Open event from firing by holding down the Shift key during startup. Since Excel 2007 it is possible to ignore this, and run your code anyway.

The sequence of events in workbooks

When you open a workbook Excel not only raises the Workbook_Open event but also a few other events. The same applies to switching worksheets, or closing the workbook. In this post I examine the sequence of activation/deactivation events in an Excel multiple window application, and with a ribbon custom tab. However, most of the findings […]