Hello Woodrow,
To add to what Logit stated:
It would depend on how knowledgeable they are with Excel and VBA.
Keep in mind that Excel is not inherently secure. Anyone with a modest understanding of VBA can circumvent your safety measures.
However, to answer your question : Yes, it is possible.
For starters, protect your VBA Project. You may also want to consider making sheets, barring one, very Hidden, until all requirements to open the Workbook are met.
Furthermore, I would suggest you enter the Code below in ThisWorkbook Event Code:
Option Explicit
Public Function GetFolderPath() As String
GetFolderPath = ThisWorkbook.Path & "/" & ThisWorkbook.Name
End Function
Private Sub Workbook_Open()
Application.DefaultFilePath = "D:/CheckPath.xlsm" 'change to suit
If Not GetFolderPath = "D:/CheckPath.xlsm" Then 'change to suit
MsgBox "Please restore this WorkBook to its correct Directory/Path", vbOKOnly, ("Access Denied")
ThisWorkbook.Saved = True
ThisWorkbook.Close
End If
End Sub
Regards.