Excel 97: Add dialog box to macro
Posted on 2002-03-30
I very much of a novice at VB and writing macros. However, I have successfully written a macro to prepare a weekly workbook for a new week. It deletes the old week and adds a new week. This new workbook should be saved under a new name and I want to make sure that the user does this. Hence I want to add a dialog box that reminds the user to save the workbook under a new name. Or, even better, a prompt would appear asking the user what the new name of the file should be and then saving it under that name in the current folder.
Hope someone can lead me through this. Thanks.