Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Protecting Hidden Areas
Having hidden cells and columns on a worksheet, when I turn my workbook file
into an Addin are the options to UNHIDE these cells/columns active to a user of the Addin. If so, is there any way to lock the user out of "fiddling" with my formatting? Thanks, |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Protecting Hidden Areas
"Ian" wrote in message
... Having hidden cells and columns on a worksheet, when I turn my workbook file into an Addin are the options to UNHIDE these cells/columns active to a user of the Addin. If so, is there any way to lock the user out of "fiddling" with my formatting? Hi Ian, All sheets in an add-in are invisible to the user. If you need to keep a worksheet visible it will have to be part of a normal workbook. You can prevent casual users from accessing hidden rows and columns by protecting the worksheet, but this is very simple to get around. It would be better to store sensitive data in a separate worksheet and set the Visible property of that worksheet as xlSheetVeryHidden using VBA or the Properties window for that worksheet in the Visual Basic Editor. You can add an additional layer of safety by protecting the VBAProject for that workbook using the Tools/VBAProject Properties menu in the Visual Basic editor. However, all of these methods (and any method that involves Excel alone) can be broken by a knowledgeable and/or determined user. -- Rob Bovey, Excel MVP Application Professionals http://www.appspro.com/ * Take your Excel development skills to the next level. * Professional Excel Development http://www.appspro.com/Books/Books.htm |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
protecting formulas without protecting sheet so grouping still wor | Excel Discussion (Misc queries) | |||
2007 Worksheet, Hidden Columns, .CSV Format Saves Hidden Column Da | Excel Discussion (Misc queries) | |||
Protecting only Hidden Rows on a Spreadsheet | Excel Worksheet Functions | |||
Protecting buttons with VB code rather than protecting sheets/books? | Excel Programming | |||
Saving hidden data with a worksheet (preferably without using a hidden sheet) | Excel Programming |