I have created an upload utility with VBA. My users access the application and select an HTML file to upload. The HTML file that is uploaded starts off as an Excel Workbook, the user saves this workbook as an HTML file. Once the file is uploaded onto the Intranet a link is created and the company users are allowed to view this page. However, the problem resides within the print feature. After the file is uploaded there is no way to print the published workbook. The only thing that we are able to print is the screen shot of the workbook, therefore leaving off half of the page.
Behind the scenes of the application, I read the file in..check for certain lines of code to add my own line of code (to disable the right click and the CTRL-A and CTRL-C buttons).
Is there any setting, or any code that I can use to set the formatting features of these published workbooks?