Thread: Can I make a worksheet protected, locked AND not viewable?
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 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:


Reply With QuoteReply With Quote