Windows Forum

Ask something
Discussion Locked

Windows 2000 Default Printer Varies

0 helpful
6 replies

by matt.mesaros

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

I'm have a windows 2000 user that is experiencing an unselected change in their default printer. For example, the user worked late printing from Excel to a local printer. Logs in early the next morning, opens the same file they were working on andprints finding that the default printer is now a network printer in another office. Due to sensitive material, no other person had access to
this users system or acount. Any ideas?

6 replies

by dklippert

Excel doesn't "Hold" a printer setting. I would assume that the remote printer became the Windows default printer when the network kicked in in the morning.
If you want to, you can add a macro to the spreadsheet that will pick the desired printer.Something like:
Sub ChangePrinter()

CurrentPrinter = Application.ActivePrinter

Application.ActivePrinter = "Standard/text only on LPT1:"

ActiveWindow.SelectedSheets.PrintOut

Application.ActivePrinter = CurrentPrinter

End Sub
If you name it Auto_Open, it will set the printer when the Workbook is opened.

by matt.mesaros

One other thing. The default system printer is the user's local printer. Don't know if this makes a difference.

by mruiz

Windows 2000 can change printer settings if on a network. For ex. you have win2k and you print to something on the network go to another win2k workstation and try printing. It'll remember the last print job to which printer and stay there until changed again manually

This discussion is closed to new replies.