Help writing code: SaveAs with dialog box visible and undo vba code to specific point in form flow

[DigitalDingers]

Hi all - have a very unique request. I need code that executes the following, can someone help me?

Backdrop - my form file has code in it that hide sheets upon open as well as clears out radio buttons and input cells. As progression through the form is achieved certain code is triggered to show the next sheet allowing user to input form data.

What I'd like to solve for is an instance where user needs to stop input flow at any given point in the process, press a button (with macro link) that retains form intake progress to said point but does not change vba code that has not otherwise been triggered... and then prompt SaveAs dialog box saving as xlsm file type.

This way when the file is reopened user can pick up right where they left off without being able to access what is to come.

Can anyone write this code? I've attempted many times and am simply stumped.

Thx - DigitalDingers

 

[Norie]

What have you tried?

Getting a SaveAs dialog is straightforward, all you need is Application.GetSaveAsFilename.

You would then follow that with code to save the file with the selected name in the selected location and then close the file.