How Can I Get a Save Prompt?

Hi folks,

I have an excel calculator that produces output on a worksheet. (All toolbars have been stripped out)

I have put in a save button, however, what is the code I need to add to this button for it to prompt the user to be able to save the output.?

I have tried:

ActiveWorkbook.SaveAs

but to no avail........

any help is appreciated.

thanks

It is possible to open up the save common dialog box through vba, but it will not accomplish what you are wanting. It will save the excel file for you.

What I would recommend is just using an inputbox to get a filename from them.