Is there anyway to have hide and lock a spreadsheet
within a workbook. I have some confidential information
for a couple sales guys that each access. I don't want
anyone to be able to see information on a different sheet.

I tried hiding and locking but the use can still go into
options and unhide. I also found VB code to hide, etc. ---
I guess my concern is to make sure that only specific
sheets can be viewed by specific users....

Make sense?

Thanks.