I am trying to program an Excel workbook, so as to minimise the user's keyboard actions. The actions I am trying to macro/prog. are as follows:

1. After data has been entered on a worksheet, activate SAVE AS for the workbook, the user then inserts a "name" for the file (XLW extension inserted automatically), accepts

2. On completion of the above, designated cells are "cleared" and workbook SAVED with a predefined name & extension

Purpose is to eliminate possible user errors. Any assistance gratfully rec'd

Dave G