Password protect or prohibit the "Save" & "Save as" option in Excel

[David77]

Hello everybody,

I am currently managing an order form in Excel, where people download it and then they go in every day, fill out the details and submit the order through a macro. They will just need to download it once and then do this whenever they have an order.

However, is there any way in which I can make it so they cannot save the file with their changes once they've downloaded it? So that the file will essentially always remain in it's alpha version with no changes being possible?

I have password protected all the cells that I don't want them to edit, but some of these cells naturally have to be edited so they can send out the order with this information. However, once they close the Excel file, I don't want them to save this information from their last order (so it does not pop up the next time they create an order).

I know that obviously they could just choose not to save the Excel file whenever they do this, but it would be nice if there was a smarter solution in order to avoid any human errors.

Does anybody know of any solutions to this problem? Would greatly appreciate!

Thank you very much for your time everybody

Best regards,
David

 

[offthelip]

you could try this in the workbook before save event:

Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As Boolean)
Cancel = True
End Sub

 

[David77]

you could try this in the workbook before save event:

Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As Boolean)
Cancel = True
End Sub

Thank you!!