Saving a Workbook
Hi
you could use the BeforeSave event of your workbook for this (note:
this is not totally bullet proof. e.g. the user disables macros).
Put the following code in your workbook module:
Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As
Boolean)
msgbox "Saving not allowed"
Cancel = True
End Sub
Or just create the workbook as readonly (protect this with a password)
--
Regards
Frank Kabel
Frankfurt, Germany
JAmes L wrote:
Hello,
Is it possible to open a new workbook and make it impossible for the
user to save the new workbook. Also let them know that they can't
save it!
Thanks in advance,
James
|