How cal I password protect a single worksheet within a workbook from viewing

You could hide the worksheet at FormatSheetHide.

Then ToolsProtectionProtect Workbook. Check Structure and Windows.

Supply a password.

Note: Excel internal workbook and worksheet security is quite weak with password
cracking programs aplenty for those determined to view your worksheet.

The general rule is...if you don't want users to see the data, don't include it
in your workbook.


Gord Dibben MS Excel MVP


On Mon, 2 Jul 2007 20:56:00 -0700, Lorne
wrote:

How cal I password protect a single worksheet within a workbook from viewing