Excel VBA - Calling Save As Dialog Box

[BGumm]

I'm lost trying to figure out how to require the user to save a workbook as something else when a certain event occurs (e.g.:

Private Sub cmdConfirmNewData_Click()

    'NEED TO BRING UP THE SAVE AS DIALOG BOX

End Sub

)

Help is very appreciated!

::Bryan

 

[AnotherHiggins]

->when a certain event occurs

what events, exactly?

Right click on the sheet tab where you want this to happen. You'll notice that you are now in the Sheet Object, not a regular Module.

At the top left corner of the Editing window, change the drop-down from (General) to Worksheet. Now look at the options in the top right drop-down.

There are different options if you double click the Workbook Object (Below the Sheet Objects, above the Modules).

[tt]_____
[blue]-John[/blue][/tt]
[tab][red]The plural of anecdote is not data[/red]

Help us help you. Please read FAQ 181-2886 before posting.

 

[BGumm]

what events, exactly?

This will happen in a form when a button is clicked.

 

[ck1999]

Try this line

Application.Dialogs(xlDialogSaveAs).Show

ck1999