Automatically Select Range Before Saving

As you can see from the code below, I am copying my report and pasting to a new workbook then saving the new workbook with a predetermined name.

Please Login or Register  to view this content.

The problem that I am encountering is that when I open the newly saved form, I am always at the bottom of the form. I would like to open the saved form and be in Range h7:ac7 automatically. It is not a big issue as I have been using it this way for around a year but it would be a nice addition. Also as the form will never need to be updated, how do I get the newly saved form to not want to be updated every time I open it up?

Thanks in advance
Keith