Home |
Search |
Today's Posts |
|
#1
|
|||
|
|||
Save As
I would like to put a button on a spreadsheet and run a macro that will bring
up the save as dialog box. |
#2
|
|||
|
|||
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. |
#3
|
|||
|
|||
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. |
#4
|
|||
|
|||
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 |
#5
|
|||
|
|||
Quote:
|
#6
|
|||
|
|||
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. |
#7
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
cannot edit and save | New Users to Excel | |||
cannot edit and save | Excel Discussion (Misc queries) | |||
cannot edit and save | Excel Discussion (Misc queries) | |||
Save & Save As features in file menu of Excel | Excel Discussion (Misc queries) | |||
Missing "Save" and "Save As" functions | Excel Discussion (Misc queries) |