I'm looking at have a userform saved in an Excel Application. The reason for
it being a userform is to give greater control over the options. Once a user
has selected the information and how they want to present it I want the
option to print it out.

Tried printing the userform and the quality is rather poor, and it doesn't
look particularly good (and isn't in Landscape) so I want to have the
information put into an excel spreadsheet and print the sheet. I'd rather
avoid linking to a specific workbook saved on the server to use as a
template, and noticed when saving the userform as an add-in that the
worksheet objects are still present in ths add-in.

Is there anyway of saving the worksheets in an addin, and being able to
reveal them and populate them?