I have a template (XLT) that has a lot of VB code that hides and unhides sheets depending on the values in cells. once entry is complete I need to save the sheets that are visible to a workbook.xls
I have the code that saves the file, but how do I code the ability to save only the sheets showing on the tabs. oh and not include the vb code aswell...