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

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

mark/mark@bramleycottage.f9.co.uk - 19 Jan 2006 19:19 GMT

I need to save timesheets as their week ending date, can i do this
automaticaly with a macro and control???
TIA

Reply to this Message

Leith Ross - 19 Jan 2006 19:43 GMT

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

Signature

Leith Ross

Reply to this Message