Preventing users from saving a spreadsheet
 

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

--
Kind Regards,
MDH

Make it read-only?
*******************
~Anne Troy

www.OfficeArticles.com
www.MyExpertsOnline.com


"MDH" wrote in message
...
Is there a way to prevent users from saving an .xls spreadsheet local or
otherwise that is located on a network share?

--
Kind Regards,
MDH

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.



MDH wrote:

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

--
Kind Regards,
MDH

--

Dave Peterson

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" wrote:

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.



MDH wrote:

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

--
Kind Regards,
MDH

--

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.



MDH wrote:

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" wrote:

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.



MDH wrote:

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

--
Kind Regards,
MDH

--

Dave Peterson


--

Dave Peterson