How to permanently change printer dialog box from print pages 1-6 to print pages 1-5?

Is there a way to permanently change the print dialog box to tell it to print pages 1 through 5 even if there are six pages?

I don't want to manually tell it to do that every time. I want it built into the excel file that whenever someone hits print it does page 1-5 only.

Any ideas?

Perhaps

Please Login or Register  to view this content.

Untested as I don't have access to a printer sat the moment. Right click on any tab in the specific workbook, then click on "View Code". In the new window that opens right click on "ThisWorkbook" and click "View Code" and paste the code in this window.

Alf