Save my spread sheet!

[Kevin K. Chlipa]

Well not really save my spread sheet but my question has to so with saveing an Excel sheet. Ill explain the best I can.

Every one knows when you save an excel sheet it give the standard "Book1.xls" for the file name to save as.

Is there a way to use a cell block to automatically name the spreadsheet. For example; If I had the word Thursday written in A1, is there a formula or macro that I can use that when I select File/Send to/
E-mail/as attachment, or File/Save, It will use the information given in cell block A1?

Any help would be appreciated!

Thanks

KC

[arthurbr]

Welcome to the forum.

Please read the Forum Rules about thread titles, and then edit yours to be descriptive of your problem.

Thanks.