I have developed a rather large estimating template in Excel 2010 that has buttons, VBA, file linking, conditional formatting, formulas, data validation, hidden tabs, named ranges, the whole 9 yards. My target with this request is to have a button that the end-user can click that will save a 3-tab, values-and-formatting-only xlsx file that the end user specifies the name of. I've basically created an estimating program using Excel (there's better/other applications for this, I know - limited company resources) and I'd like when the user saves their generated estimate, it's only a very small, "dumb" file, not a massive multi MB file. The large template file contains an instructions tab followed by 2 hidden data tabs referenced throughout the workbook, followed by a general input tab followed by multiple specific input tabs. The last 2 tabs are a bill of materials/shop labor tab and then a field labor/details tab; the 3 tabs I would like to save are the general input tab, the shop labor/BOM tab, and the field labor/details tab. Since this template has VBA code, file linking, formulas, etc., I would like to retain only a different, defined range of cells on the 3 tabs, the displayed values in each cell of the defined range on those 3 tabs, and the displayed cell formatting on those tabs; it needs to be a compact file, "look pretty", and "be dumb". Due to sensitivity of information in the template, I can not post the template here and I do need to save the generated estimates as excel files for other in-house data analysis functions. Hopefully this request makes sense and is possible?
Thank you for your time