I have made a sheet that has been divided up into 40 pages using page breaks. On this sheet there are 40 different buttons that have macros attached to them that will print a certain page depending on what button is pressed. This works great until the user presses the print icon along the tool bar and 40 pages print out!
Is there anything that I can do to either disable this icon or preferably only print the current page when it is pressed?
Thank you very much for any help, I have no idea how to resolve this!![Eek! :eek: :eek:](data:image/gif;base64,R0lGODlhAQABAIAAAAAAAP///yH5BAEAAAAALAAAAAABAAEAAAIBRAA7)
Is there anything that I can do to either disable this icon or preferably only print the current page when it is pressed?
Thank you very much for any help, I have no idea how to resolve this!