Can I make a worksheet protected, locked AND not viewable?
 

--
Mike @ Contractors

Can I make a worksheet protected, locked AND not viewable?
 

"MBozeman" wrote in message
...

--
Mike @ Contractors

Use a password?

V

Can I make a worksheet protected, locked AND not viewable?
 

You can make them veryhidden through VBA and user will not be able to unhide
them by going to FormatSheetUnhide.

Sheets("Sheet1").Visible = xlVeryHidden

But user may figure out a way to unhide them

Sheets("Sheet1").Visible = True

Excel's internal security is very weak and difficult to lock down everything
completely.

My suggestion is...............if you don't want someone to see something,
don't include it in the workbook.


Gord Dibben MS Excel MVP


On Sat, 13 Mar 2010 13:28:01 -0800, MBozeman
wrote: