Printing a Spreadsheet control
How can I a spreadsheet in an ActiveX control (Microsoft Office 11.0 Spreadsheet Control)? I've tried the 'PrintOut' and 'PrintPreview' methods which are supposed to work, but VBA insists that the 'Object does not support this property or method'. :confused:
Re: Printing a Spreadsheet control
Looks like alll you can do is set the .PrintObject = True for the spreadsheet component. Then when you .PrintOut your spreadsheet then child control will print also.
Here is a link to the MSDN page.
http://msdn.microsoft.com/library/de...HV05204190.asp