I would like to put a button on a spreadsheet and run a macro that will bring
up the save as dialog box.

Application.GetSaveAsFilename

you can look up GetSaveAsFilename method in help

--
Regards,

Peo Sjoblom

(No private emails please)


"bbc1" wrote in message
...
I would like to put a button on a spreadsheet and run a macro that will
bring
up the save as dialog box.

Do you realize that you can add the existing command icon to your toolbar?

Right click on the toolbar and choose "Customize".
Click the "Commands" tab and in the left window click "File".
Scroll down in the right window and click on "Save As",
And drag it to your ToolBar.

Since this command has only a text icon, and no default image icon assigned
to it, you can then click on "Modify Selection",
Then click "Change Button Image", and choose one of the icons in that
window.
--

HTH,

RD
================================================== ===
Please keep all correspondence within the Group, so all may benefit!
================================================== ===


"bbc1" wrote in message
...
I would like to put a button on a spreadsheet and run a macro that will
bring
up the save as dialog box.

You could hit F12, too.

bbc1 wrote:

I would like to put a button on a spreadsheet and run a macro that will bring
up the save as dialog box.

--

Dave Peterson

Thankyou found a script on this which I could apply to a command button on
the worksheet
Application.ExecuteExcel4Macro("SAVE.AS?()")

"Peo Sjoblom" wrote:

Application.GetSaveAsFilename

you can look up GetSaveAsFilename method in help

--
Regards,

Peo Sjoblom

(No private emails please)


"bbc1" wrote in message
...
I would like to put a button on a spreadsheet and run a macro that will
bring
up the save as dialog box.

Or even:

Application.Dialogs(xlDialogSaveAs).Show



bbc1 wrote:

Thankyou found a script on this which I could apply to a command button on
the worksheet
Application.ExecuteExcel4Macro("SAVE.AS?()")

"Peo Sjoblom" wrote:

Application.GetSaveAsFilename

you can look up GetSaveAsFilename method in help

--
Regards,

Peo Sjoblom

(No private emails please)


"bbc1" wrote in message
...
I would like to put a button on a spreadsheet and run a macro that will
bring
up the save as dialog box.



--

Dave Peterson

AaAaAaAaAaAagggghhhhh.........