I wish to apply a password for internal documents (PPTX, DOCX, XLSX..) , that will not be opened out of company.
I assume should be some some Window Log-In validation.
Please your help with the code..
I wish to apply a password for internal documents (PPTX, DOCX, XLSX..) , that will not be opened out of company.
I assume should be some some Window Log-In validation.
Please your help with the code..
I wish to apply a password for internal documents (PPTX, DOCX, XLSX..) , that will not be opened out of company.
I assume should be some some Window Log-In validation.
Please your help with the code..
Here is it to all that may be interested in Excel:
Private Sub Workbook_Open()
Dim pass, valid As String
Windows(ThisWorkbook.Name).Visible = False
pass = "XXX"
valid = InputBox("Password?")
If Environ("USERDOMAIN") <> "YYY" Or valid <> pass Then
ThisWorkbook.Saved = True
ThisWorkbook.Close
Else
Windows(ThisWorkbook.Name).Visible = True
End If
End Sub
Display More
Any idea for a same solution in PPT and DOC files?
Don’t have an account yet? Register yourself now and be a part of our community!