Preventing users from saving a spreadsheet

M

MDH

Is there a way to prevent users from saving an .xls spreadsheet local or
otherwise that is located on a network share?
 
D

Dave Peterson

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

MDH

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.
Click to expand...
 
D

Dave Peterson

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.

Perhaps I should look into Group Policy...?
Click to expand...
 
Top