Do not allow saveAs

Topic

New Reply

I want to control a workbook with a macro. I want to prevent people from saving to a new location. Is there a simple way to stop the “SaveAs”?

If not, I can write code to check the path in the Workbook_BeforeSave routine.

Thanks.

Reply | Quote

Replies

I figured it out. It is easy. Initially I tried setting SaveAsUI to false, to cancel the save as. I need to trap it instead.

Thanks.

Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As Boolean)

If SaveAsUI = True Then
Cancel = True
End If

End Sub

Reply | Quote