I need to people to access the excel workbook but need to lock them out of one particular sheet in that workbook.

On that sheet select Tools > Protection > Protect Sheet and add a password.