Forcing a "Save As"

  • Thread starter Thread starter dpaulus
  • Start date Start date
D

dpaulus

I have a data form that various users use. Is there a way to force
"Save As" dialog box to pop up whenever the user either prints the for
or attempts to exit the program?

Apparently the "Do you wish to save the changes in this form?" box tha
appears when we attempt to exit now isn't working. =)

Thnaks for any advice
 
If I make a change to a workbook and then try to close it, I get excel's built
in: "Hey, you changed something--wanna save it?"

And if you mark your file as ReadOnly (it's a "master" workbook???), they'll get
the SaveAs dialog.

And for the printing version, you can tap into a workbook event:

Option Explicit
Private Sub Workbook_BeforePrint(Cancel As Boolean)
If Me.Saved = False Then
Application.Dialogs(xlDialogSaveAs).Show
End If
End Sub

But I'd find this more than irritating. I'd come after you!!! <bg>.

(It'll pop up with print|preview, too.)
 
Back
Top