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.


--
grahammal
------------------------------------------------------------------------
grahammal's Profile: http://www.excelforum.com/member.php...o&userid=20336
View this thread: http://www.excelforum.com/showthread...hreadid=518959