B
bbc1
I would like to put a button on a spreadsheet and run a macro that will bring
up the save as dialog box.
up the save as dialog box.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
P
Peo Sjoblom
Application.GetSaveAsFilename
you can look up GetSaveAsFilename method in help
--
Regards,
Peo Sjoblom
(No private emails please)
you can look up GetSaveAsFilename method in help
--
Regards,
Peo Sjoblom
(No private emails please)
R
RagDyeR
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!
=====================================================
I would like to put a button on a spreadsheet and run a macro that will
bring
up the save as dialog box.
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!
=====================================================
I would like to put a button on a spreadsheet and run a macro that will
bring
up the save as dialog box.
D
Dave Peterson
You could hit F12, too.
I would like to put a button on a spreadsheet and run a macro that will bring
up the save as dialog box.
B
bbc1
Thankyou found a script on this which I could apply to a command button on
the worksheet
Application.ExecuteExcel4Macro("SAVE.AS?()")
the worksheet
Application.ExecuteExcel4Macro("SAVE.AS?()")
D
Dave Peterson
Or even:
Application.Dialogs(xlDialogSaveAs).Show
Application.Dialogs(xlDialogSaveAs).Show
B
BizMark
bbc1 said:Thankyou found a script on this which I could apply to a command button
on
the worksheet
Application.ExecuteExcel4Macro("SAVE.AS?()")
:
-
Application.GetSaveAsFilename
you can look up GetSaveAsFilename method in help
--
Regards,
Peo Sjoblom
(No private emails please)
"bbc1" [email protected] 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.-
-
AaAaAaAaAaAagggghhhhh.........