Require a SAVE AS when msgbox answer = yes

**clemsoncooz** · 02-13-2012, 03:56 PM

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** · 02-13-2012, 04:19 PM

try something like this in THISWORKBOOK module

Please Login or Register  to view this content.

**clemsoncooz** · 02-13-2012, 04:25 PM

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** · 02-13-2012, 04:29 PM

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** · 02-13-2012, 04:37 PM

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** · 02-13-2012, 05:27 PM

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