View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Gord Dibben Gord Dibben is offline
external usenet poster
 
Posts: 22,906
Default Protect just one worksheet of an excel doc?

If you want the sheet hidden and not available use ToolsProtectionProtect
Workbook after hiding the sheet.

But note Peo's caveat about Excel internal security.


Gord Dibben MS Excel MVP

On Wed, 26 Sep 2007 09:04:07 -0700, CDS wrote:

I have a large excel document, and one of the worksheets within the document
is very confidential. Is there a way to password protect just that one
worksheet within the document?