ok i figured part of it out....

It saves everything but it is saving the file with the workbook hidden. You have to manually go in and unhide the workbook.

There has to be a way to save this with the workbook visible.


Any Ideas ?