I've tried searching, perhaps not long enough, for a pre-written macro
code that, when you save the file as, the filename is automatically the
value in a particular cell of a particular sheet.

I have no experience with macros, and changing the codes I HAVE found
to work for me has been of little success :(

The file is a template for invoices, and on one sheet (named DETAILS)
in cell B2 is the invoice number we enter - so when the file is saved I
want the filename to be that number!

How would I write the code, but then also save it and make sure it runs
whenever the file is open?

Any help much appreciated

Thanks
Alex


--
alex3867
------------------------------------------------------------------------
alex3867's Profile: http://www.excelforum.com/member.php...o&userid=37220
View this thread: http://www.excelforum.com/showthread...hreadid=569909