What's the safest way to NOT allow user from Saving

[APPPRO]

I don't want the user the ever "Save"

Save As is OK.

Any thoughts?

 

[Richie(UK)]

Hi,

How about:
<pre>Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As Boolean)
If Not SaveAsUI Then Cancel = True
End Sub</pre>
In the ThisWorkbook module.

HTH

 

[Mark W.]

How about using a Modify password and setting the Read-only recommended option? See the Excel Help topics for "Set properties to make a workbook read-only", "Protect workbooks and worksheets from changes", and "Require a password to save changes to a workbook".

 

[APPPRO]

neither works.

1st idea - it still saves when you click the save icon button

2nd is no good cause can't be read only

any macros that Stop the Save???

 

[Mark O'Brien]

<pre>
Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As Boolean)
Cancel = True
End Sub</pre>

The only problem with this is that you can't save your workbook to distribute it.

 

[Legacy 11273]

On 2002-10-21 17:41, APPPRO wrote:
1st idea - it still saves when you click the save icon button

The procedure supplied by Richie(UK) works.

Are you putting it in the ThisWorkbook module?

You might want to add a message :-

Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As Boolean)
If Not SaveAsUI Then
Cancel = True
MsgBox "Changes to this workbook cannot be saved. Use SaveAs instead."
End If
End Sub
This message was edited by Bali on 2002-10-21 18:01

 

[APPPRO]

GREAT!!!!

Had it in wrong module.

terrific

 

[APPPRO]

Working great - especially the message too. love that.

BUT you can save the workbook. yeah yeah save as.

got to remmeber.

thanks again

 

[stevebausch]

depends how obsessive you are.

It is possible to run Windows from a CD.
It is possible to set up a RAM drive.
And of course, Using Window NT or 2000, you can 'Lock Down' the workstation so nothing can be saved.

I think the real path is to use a operating system that you can lock down.

 

[brettvba]

Whats the difference to having SaveAs only you can still save the file by just not changing the filename!

Brett