|
|
Can I make a worksheet protected, locked AND not viewable?
--
Mike @ Contractors
|
|
0
|
|
|
|
Reply
|
 Utf
|
3/13/2010 9:28:01 PM |
|
"MBozeman" <Contractor@elmore.rr.com> wrote in message
news:7BC19572-9200-4982-B9FA-7671F5EA80BD@microsoft.com...
>
> --
> Mike @ Contractors
Use a password?
V
|
|
|
0
|
|
|
|
Reply
|
Victor
|
3/13/2010 11:13:02 PM
|
|
You can make them veryhidden through VBA and user will not be able to unhide
them by going to Format>Sheet>Unhide.
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 <Contractor@elmore.rr.com>
wrote:
|
|
|
0
|
|
|
|
Reply
|
Gord
|
3/13/2010 11:31:18 PM
|
|
|
2 Replies
351 Views
(page loaded in 0.04 seconds)
Similiar Articles: 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 Format>Sheet>Unhide. Sheets("Sheet1").Visible = xlVeryHidden But user ... Can't insert row in data table in protected worksheet ...Can I make a worksheet protected, locked AND not viewable ... Can't insert row in data table in protected worksheet ... Can I make a worksheet protected, locked AND not ... macro to unlock and lock cells in password protected sheet ...Can I make a worksheet protected, locked AND not viewable ... macro to unlock and lock cells in password protected sheet ... Hi all Is there any way I can get a macro to ... Excel; tabbing through protected worksheet - microsoft.public ...Can I make a worksheet protected, locked AND not viewable ... Excel; tabbing through protected worksheet - microsoft.public ... Can I make a worksheet protected, locked ... Sorting in a protected sheet - microsoft.public.excel.misc ...Can I make a worksheet protected, locked AND not viewable ... Sorting in a protected sheet - microsoft.public.excel.misc ... Can I make a worksheet protected, locked AND ... Code not working in a PROTECTED Worksheet - microsoft.public.excel ...Can I make a worksheet protected, locked AND not viewable ... Allow VBA code to change a locked cell?? - microsoft.public.excel ... ... Auto filter sort ascending not ... How can I Unlock cell/worksheet? - microsoft.public.excel.misc ...Can I make a worksheet protected, locked AND not viewable ... How can I Unlock cell/worksheet? - microsoft.public.excel.misc ... Can I make a worksheet protected, locked ... Sorting tables on protected worksheets - microsoft.public.excel ...Can I make a worksheet protected, locked AND not viewable ... Can't insert row in data table in protected worksheet ... Can I make a ... Can I make a worksheet protected ... Allow selection of Validation List in a Protected Cell - microsoft ...Can I make a worksheet protected, locked AND not viewable ... Allow selection of Validation List in a Protected Cell - microsoft ... Using XL 2003, is it possible to lock ... Make Worksheet Deactivate Event only run once - microsoft.public ...Can I make a worksheet protected, locked AND not viewable ... Make Worksheet Deactivate Event only run once - microsoft.public ..... all worksheets with macro - microsoft ... 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 Format>Sheet>Unhide. Sheets("Sheet1").Visible = xlVeryHidden But user ... Lock or unlock specific areas of a protected worksheet - Excel ...When you protect an Excel 2007 worksheet, you can lock specific cells before you protect the worksheet. You can also unlock a range of cells for editing. Protect Sheet; Locked Cells Can Be Modified // Data Validation Not ...I have cells that are locked and the worksheet and workbook are password protected. Is it possible to suppress the Excel message (ie the one that says the cells are ... Excel - How Do I Make Column Headers Viewable As I Scroll Down The ...how can I lock it so that they can not scroll right/left off the viewable ... some strange behaviour with Excel on a Protected Worksheet I am ... Overview of security and protection in Excel - Excel - Office.comUsers can't sort ranges that contain locked cells on a protected worksheet, regardless of this setting. Use AutoFilter: Using the drop-down arrows to change the filter on an ... 7/26/2012 7:21:18 PM
|
|
|
|
|
|
|
|
|
Search |
Post Question |
Groups |
Stream |
About |
Register
66 followers. 