Excel VBA - Calling Save As Dialog

[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]

Please repost this VBA-specific question in forum707.

[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.