I have a Print macro button on my spreadsheet that sets the print area, hides certain rows and prints.
Is there a bit of VB that will let me set up the save options much like the 'Save As' option.
ie File name, and where to save.