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

[mark/[email protected]]

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
----------------------------------------------

[Leith Ross]

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. Select the cell that contains the date, and 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