Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Can I make a worksheet protected, locked AND not viewable?
-- Mike @ Contractors |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Can I make a worksheet protected, locked AND not viewable?
"MBozeman" wrote in message
... -- Mike @ Contractors Use a password? V |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Using solver function in a locked (protected) worksheet | Excel Worksheet Functions | |||
Can I use solver functions in a protected (locked) worksheet? | Excel Discussion (Misc queries) | |||
Locked worksheet & hyperlinks (w/ select locked cells unchecked) | Excel Discussion (Misc queries) | |||
History worksheet - can it remain viewable after saving? | Excel Worksheet Functions | |||
Heps to design Locked/Unlocked cells in protected worksheet | Excel Discussion (Misc queries) |