forgot to tell you, I have the following in the ThisWorkbook object:
Private Sub Workbook_Open()
'go to sub to verify it is authorized copy of file
proVerifyPathName
'loads and shows frmVancomycin when Excel opens
Load frmVancomycin
frmVancomycin.Show
End Sub
And, of course, you can change the comments in the message box if
someone tries to run from somewhere else.
Let me know if this works for what you want.