Require a SAVE AS when msgbox answer = yes

[clemsoncooz]

I am creating a TEMPLETE workbook.

When this workbook opens, the first thing I do is ask the user if they are starting a new project.

Please Login or Register  to view this content.

How do I require the standard Microsoft "SAVE FILE AS " dialog box, after the user chooses YES ?? ( I want this to be the first thing to occur once the chose yes.


UPDATE: Let me specify further....and once they do "save file as" but then continue on with my current coding (which is quite long if they do select yes).

[tom1977]

try something like this in THISWORKBOOK module

Please Login or Register  to view this content.

[clemsoncooz]

Thanks Tom 1977.

I noticed you dont have a vbNo part that goes with my varAnswer.

I do. Does the "Set Wind = Nothing" line go with my vbNo code?

[tom1977]

Hi
No it only clears the variable "WIND"
You did not write what You want after choose "no" so I did not put this into code

[clemsoncooz]

Very cool. I believe this is working just the way I asked (so far).

Thank you so much!

Any way to change the default save file type as "Excel-Macro Enabled Workbook" (xlsm) RATHER than the Exel Workbook (xls) type so the user doesnt have to change it? Because I do want them to save it as macro enabled (xlsm).

[tom1977]

Sorry I have checked all methods and properties of this object FileDialog(msoFileDialogSaveAs) but I did not find the one which set this automatically to FileFormat:= xlOpenXMLWorkbookMacroEnabled
Maybe someone else could find solution