In Excel, is there any way to lock a sheet?

Question

In excel, a new workbook starts with 3 sheets, is there any way to protect one sheet so that "sheet2" is non-viewable unless you unlock it by password?

Thanks

Answer 1

Yes. This link will show you how. Very easy.

http://www.techonthenet.com/excel/sheets/hide.php

Answer 2

You might want to mess with this VBA code as well:

Function HideSheet(SheetName As String)

ActiveWorkbook.Sheets(SheetName).Visible = xlVeryHidden

End Function

This prevents a user from just unhiding the sheet, i.e. it won't show up in the list when they select Format --> Sheet --> Unhide.

The Data Analyst - http://www.squidoo.com/thedataanalyst

Answer 3

Tools>Protection>protect sheet