Area automatically being cleared every time a file is opened

[intsoccersuperstar]

Hello,

I am running into a problem where a certain area of my excel file is being cleared every time it is opened, and I can't figure out why - there is no VBA written in it that would specifically do this, so I'm wondering if someone somehow set up an option in an Excel menu to do this. To give a little background, this file has two tabs, the "Front Page" and the "Data tab". In the "Front Page", there are two buttons. The "Run" button runs a webquery that pulls data from the web and dumps it on the "Data tab". The second button, the "Populate" button, populates a section of the "Front page" with the data that was dumped into the "Data Tab".

If I save this file, close it, and reopen it, the section of the "Front page" that was previously populated is now empty. The data the webquery pulled onto the "Data tab" is still there, and can be brought back to the "Front Page" by hitting the "Populate" button, but I can't figure out why the "Front page" is being blanked out in the first place. As far as I can tell no VBA exists that would clear this section upon the file closing or upon open. Is there a setting on a different menu in Excel that could cause this?

Thanks in advance!

 

[Joe4]

Can you post all the VBA code that exists in the:
- ThisWorkbook module?
- Front page module?