CODEWITHSUNDEEP
vbams-office
Andrew
Andrew

Reputation: 11

How to disable SaveAs in Ms word in vb.net

How can i disable Save as in MS word or in any other office using vb.net?

Upvotes: 1

Views: 1026

Answers (1)

djadmin
djadmin

Reputation: 1760

You need to use VBA Macro to disable Save As Option. Code to disable in Excel is :

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

'This macro disables the "Save As" Feature in Excel
'This means that a user will not be able to save this
'workbook(file) under a different name or in a different location
'
'This MUST be placed in "ThisWorkbook" and NOT in a Module.
'

    If SaveAsUI = True Then Cancel = True

End Sub

Upvotes: 1

Related Questions