Worksheet password
FormatSheetHide.
ToolsProtectionProtect Workbook with a password.
Note: Excel's internal security is very weak and passwords easily cracked.
My advice is..............if you don't want someone to see data in a workbook,
don't include the data in that workbook.
Gord Dibben MS Excel MVP
On Sun, 13 May 2007 09:36:01 -0700, Dr Alok Modi MD
wrote:
Hi !
I know that you can prevent other users from opeing your excel book by
locking it with a password. But my incomes workbook has 8 sheets out of which
one sheet is confidential. I do not want somebody to to be able to prview
that sheet without a password. I do not mind if other worksheets are open to
public view in the same workbook. I have not been able to find a solution to
that. Could you help me out ?
Thanks
Dr Alok Modi MD
|