Gridlines and zoom in newly created workbook with VBA

Hi,

I have the following piece of code that will select some of my worksheets from a template and copy/paste them in a new worksheet and rename it as well. The code works just fine, without any issues. But due to the nature of my reports I need to set the gridlines = true and zoom = 70% in the newly created file. I tried adding some pieces of code into it but without results. I am hoping that anyone may have an idea on how to do it. The zoom is not so important, but I really need the gridlines to be set to true.

Thank you.

Please Login or Register  to view this content.

Hi Greg, thank you for your solution. So easy and so elegant. Brilliant!

Sorry to bother you Greg, but I hope that you may point me out in the right direction. If I have 3 graphs in one of the tabs copied how can I copy them into the new file as well? it seems that my current code doesn't copy them

EDIT: Added one piece of code after grouping the charts and fixed my problem

Please Login or Register  to view this content.