I have a command button in a spreadsheet with the following code attached to it
How can I change the printer back to the original default printer after the button is used to print the sheet? The added complexity to this is that it is a shared file and there are a number of default printer across all users
Please Login or Register to view this content.
Last edited by dperry; 04-15-2009 at 08:49 PM.
Save the value of Application.ActivePrinter, and then restore it after you print.
Entia non sunt multiplicanda sine necessitate
can you give me an example of how the code for this would look? thanks
If that sorts it, would you please mark the thread as Solved?Please Login or Register to view this content.
Click the Edit button on your first post in the thread
Click Go Advanced, select [SOLVED] from the Prefix dropdown, then click Save Changes
Last edited by shg; 04-15-2009 at 07:23 PM.
works like a dream! many thanks for your help
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks