| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Command Button Prompt Save As?
Is it possible to have a command button or Macro that can prompt the
user the Save As Dialog ? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Command Button Prompt Save As?
Sure -
Sub MySave() Application.Dialogs(xlDialogSaveAs).Show End Sub "Rich" wrote: Is it possible to have a command button or Macro that can prompt the user the Save As Dialog ? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Command Button Prompt Save As?
Thank you! I'm extremely new.
How about a some sort of close after the save is made? Private Sub CommandButton1_Click() Application.Dialogs(xlDialogSaveAs).Show Application.Close?? End Sub |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Command Button Prompt Save As?
Found it!
Application.Quit |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| save prompt for user exit, but no save prompt for batch import? | Excel Discussion (Misc queries) | |||
| AutoSave: How can I get it to save every 5 minutes & NO prompt? | Excel Worksheet Functions | |||
| Save? prompt when closing Excel | Excel Discussion (Misc queries) | |||
| Save prompt | Excel Discussion (Misc queries) | |||
| Save prompt for Excel 2003 | Setting up and Configuration of Excel | |||
Linear Mode
