Thank you.
I was hoping there might be a way to prevent the "Save As" function outside
of creating a macro. Looks like there are no 'magical microsoft push of the
button' solutions to this one.
Perhaps I should look into Group Policy...?
--
Kind Regards,
MDH
Dave Peterson said:
Not really.
Any suggestion would probably be macro based and if the user disabled macros (or
disabled events), then they could do what they want.
Microsoft added a bunch of stuff concerning IRM (Intellectual Rights Management)
in Office 2003 (IIRC). I've never used it, but you may want to look at help for
more info.
And you could use a macro that stops the save.
This goes under the ThisWorkbook module:
Option Explicit
Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As Boolean)
MsgBox "no, no, no!"
Cancel = True
End Sub
But all users have to do is disable events (or completely disable macros) and
they can do anything that they want.
Thank you.
I was hoping there might be a way to prevent the "Save As" function outside
of creating a macro. Looks like there are no 'magical microsoft push of the
button' solutions to this one.
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.
