how to prompt for action when user clicks save

  • Thread starter Thread starter Mark
  • Start date Start date
M

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.
 
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
 
Back
Top