I have a workbook with 12 sheets January->December
I need a macro that saves the active sheet, but it needs to kill all refrences within it(it reads from other workbooks) - I need to import it into a program that doesn't allow other than values.
I must not change formatting, as some columns are formatted as text, date etc.
If it can save in the same location as the workbook it would be fine - just naming it the same as the active sheets name.
Bookmarks