Change/restore default printer in Excel vba (to allow color printing)

[BobEulberg]

As I understand it...when the default printer is b&w, Excel will always print b&w, regardless of what printer is selected in the print menu. So on the Print event I'd like to store the current default, change it to a color default (our pdf converter should work), let them choose their printer, and then restore their default so we're not wasting color ink all over the country.

Sidenote: When you select our pdf converter (on LPT1) it saves in color even though the default is b&w. Maybe this is because it's on LPT1 and not the network? Just curious.

I found a step in the right direction (

http://www.tek-tips.com/faqs.cfm?fid=1635),

but I still need functions to get and save registry settings. If I knew how to get and save registry settings (and which registry setting is the default) I could figure the rest out. Can someone please help with this?

Thanks so much! Bob