Macro Printing & Save as PDF Problem

[alexshaw76]

New to using VBA in excel

I've created buttons to be able to print the active sheet and to print the whole workbook less the hidden sheets. Is there a way to add code to make sure that excel is selecting the default printer?
Active sheet code:

Please Login or Register  to view this content.

Print whole workbook less hidden sheets code:

Please Login or Register  to view this content.

Help is much appreciated.

[Solus Rankin]

Hello alexshaw76,

Unfortunately your post doesn't comply with rule #3. Please read through the forum rules http://www.excelforum.com/forum-rule...rum-rules.html

3. Use code tags around code. Posting code without them makes your code hard to read and difficult to be copied for testing. Highlight your code and click the [#] button at the top of the post window (if you are editing an existing post, press Go Advanced to see the [#] button). The result will appear like this in the post window:

[code]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/code]

... and appear like this when posted:

Please Login or Register  to view this content.

Once this has been corrected we can help you.