Hiding a sheet in Excel 2007 (with a password) OR hide VBA code in Excel - Stack Overflow

Here is what you do in Excel 2003: In your sheet of interest, go to Format->Sheet->Hide and hide your sheet. Go to Tools->Protection->Protect Workbook, make sure Structure is selected, and enter your password of choice. Once this is done, the sheet is hid

stackoverflow.com