how to prompt for action when user clicks save

[Mark]

I want to be able to prompt a user to save a file in a
specific location when the user clicks Save (this
particular file must be saved in two locations, and I
don't want to rely on people remembering to do this
manually). Is this possible to do through a dialog box or
some other means? It would also be OK with me if the save
to the second location happened automatically, but I
think maybe for security reasons that it is not possible.

 

[Frank Kabel]

Hi
one idea: Put the following in your workbook module:

Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As
Boolean)
msgbox "Don't forget to save twice" 'change this to your needs
End Sub