This is kind of an out-of-the-box way of dealing with it but...



In each of your worksheets  add this little code



Private Sub Worksheet_Activate()

Sheets("sheetname").Select

End Sub



This makes it so anytime a user  tries to open  another worksheet  the
workbook automatically reopens the only worksheet you want them to see,
thus denying them the ability to see or manipulate the worksheet. Like
I said out-of-the-box but effective