I have an aggravating issue that I have no idea where to look for the source. I've built an application using Userforms and "userform menus" that totally isolate the user from Excel. Data is gathered in a variety of user forms and deposited or updated on a main "Data Table" worksheet. One of the reports that I have coded loops thru the Data Table and gathers certain data bits and places them on another worksheet that the code then prints out. After printing, the code then deletes the data leaving an essentially blank worksheet. Initially, the title row was fixed in place and not deleted; data was added starting with row 2.

When I run the code directly from the VBE, the reports prints fine. However, when I run the code from one of the user menus, the title row is written over with the data; i.e. data is deposited beginning in row 1.

In an attempt to circumvent the issue, I deleted the title row and added code to the procedure that built the title row and then began adding the data bits. This didn't work as it results in the same issue.

FWIW, the code is written in VBA 6.5 running in Excel 2007 (12.0.6683.5002) SP3 MSO (12.0.6683.5000) running in a terminal server environment.

Any suggestions would be greatly appreciated.