View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Gord Dibben Gord Dibben is offline
external usenet poster
 
Posts: 22,906
Default Hide sheet in workbook

You can hide a sheet and password protect the workbook under
ToolsProtectionProtect Book.

Just be aware that Excel internal passwords are very easy to crack.

You could through VB Editor make the sheet xlveryhidden then put password
protection on the VBA project. This password is a little harder to crack.

In general........if you don't want someone to see it, don't include it in the
workbook.


Gord Dibben MS Excel MVP

On Wed, 26 Jul 2006 16:26:52 -0400, rbrickl
wrote:


How would I hide a worksheet in a workbook if I don't want people to see
if I sent the workbook to them. I still want this sheet though because
it affects the main sheet.

Thanks