Code only work in specific folder location

[PhilMc]

Good morning. Is it possible to create VBA code that will only work when a workbook is opened from a specific folder location? I am trying to restrict users to only use a specific version and location of a workbook. Thanks

 

[JonXL]

Try this:

If ThisWorkbook.Path <> "[your path you want the user restricted to using]" Then
     Exit Sub
Else
End If

 

[PhilMc]

Try this:

If ThisWorkbook.Path <> "[your path you want the user restricted to using]" Then
     Exit Sub
Else
End If

Thanks JonXL - that works perfectly!!