 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / Programming / March 2008Hide a Spreadsheet in an Add-in
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? To expose an addin toggle the IsAddin property which is found in the properties for thisworkbook. My suggestion would be to create the template sheet in your addin and then copy that sheet to a new workbook when you want to expose it.  SignatureHTH... Jim Thomlinson > 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 [quoted text clipped - 10 lines] > Is there anyway of saving the worksheets in an addin, and being able to > reveal them and populate them? I don't really follow what you want to do. Print the form but the quality is not good? So you want to put info on a sheet, fair enough but why not simply add a new workbook and put your info on that. Workbooks.Add You can of course keep info on a sheet in your addin which of course will remain hidden. You could update info on the sheet and save when required. You could print it in the normal way or if you want to make it viewable simply do this - Thisworkbook.Worksheets(1).Copy Regards, Peter T > 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 [quoted text clipped - 10 lines] > Is there anyway of saving the worksheets in an addin, and being able to > reveal them and populate them? I don't want to add a workbook and then have 500 lines of code to get the text and formatting right before adding in the figures. > Thisworkbook.Worksheets(1).Copy Works perfectly thanks. Now I can set it all out and just run that then put the data in so the user can print/save whatever they want.# Cheers! > I don't really follow what you want to do. Print the form but the quality is > not good? So you want to put info on a sheet, fair enough but why not simply [quoted text clipped - 28 lines] > > Is there anyway of saving the worksheets in an addin, and being able to > > reveal them and populate them? |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.