how do u use a cell value for the save to filename
 

I need to save timesheets as their week ending date, can i do this
automaticaly with a macro and control???
TIA
--
----------------------------------------------
Posted with NewsLeecher v3.0 Final
* Binary Usenet Leeching Made Easy
* http://www.newsleecher.com/?usenet
----------------------------------------------

how do u use a cell value for the save to filename
 

Hello Mark,

Yes you can do this. Here is macro to rename the Active Worksheet to
whatever the Active Cell contains. Add A VBA module to your Workbook
and copy the macro code into it. You can then select the macro from the
Macro List (press the ALT key and then press F8 to bring it up) and run
it without using a control.

Macro Code:

Sub RenameSheet)
ActiveSheet.Name = ActiveCell.Value
End Sub

Sincerely,
Leith Ross


--
Leith Ross
------------------------------------------------------------------------
Leith Ross's Profile: http://www.excelforum.com/member.php...o&userid=18465
View this thread: http://www.excelforum.com/showthread...hreadid=503031