Hi,
I am sure this is a very straight forward query. However I am struggling to find the answer, I have a couple of worksheet, which have a few embedded charts on them each. I am trying to set up a user form, which will either print both worksheet print areas, just the one worksheet, or give the option of printing the charts on a full page individually.
If I copy the charts onto their own sheets then this is straight forward, however ideally I want to keep the worksheets as they are and just print the graphs directly from there if that option is ticked.
Any help will be greatly appreciated.
Thanks,
Chris
I am sure this is a very straight forward query. However I am struggling to find the answer, I have a couple of worksheet, which have a few embedded charts on them each. I am trying to set up a user form, which will either print both worksheet print areas, just the one worksheet, or give the option of printing the charts on a full page individually.
If I copy the charts onto their own sheets then this is straight forward, however ideally I want to keep the worksheets as they are and just print the graphs directly from there if that option is ticked.
Any help will be greatly appreciated.
Thanks,
Chris