Forcing a "Save As"

[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

 

[Dave Peterson]

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

 

[dpaulus]

Thanks for the help Dave