Hello Everyone,

I have made a sheet that has been divided up into 47 pages. Each page has a macro on a button that when the button is pressed will only print the current page. The problem is that the users are not using the button with the macro on it but the tool bar print button that by default prints every page (47 in total!). They only ever need to print the current page and never all pages! Is there any way that the print button on the tool bar can be configured to only print the current page in view when it is clicked on? Perhaps some code that will be activated when the print icon is pressed?

Thank you very much for any help

Margate