Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Best way to protect sheets and document.
Hello,
I have several Excel files with many calculated formula and information that need to be protected from users. I want the Excel file to not show formula, formatting and want users not to be able to change certain cells that contain important information. The file also have grouping that expand when click on the "plus" sign. If I protected with the TOOLS/PROTECTION method, I or user won't be able to expand the tree. Is there a programming code that can solve this problem? Thanks |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Best way to protect sheets and document.
Worksheets have an "EnableOutlining" property, which you would have to set
top True each time the workbook is opened. -- Jim Rech Excel MVP "Luong" wrote in message ... | Hello, | | I have several Excel files with many calculated formula | and information that need to be protected from users. I | want the Excel file to not show formula, formatting and | want users not to be able to change certain cells that | contain important information. The file also have grouping | that expand when click on the "plus" sign. If I protected | with the TOOLS/PROTECTION method, I or user won't be able | to expand the tree. | | Is there a programming code that can solve this problem? | Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Using Track Changes to protect just part of a document | Excel Discussion (Misc queries) | |||
Track Changes and Password Protect a Document | Excel Discussion (Misc queries) | |||
how can i protect a document so nobody can delete it | Excel Discussion (Misc queries) | |||
how can i protect a document so nobody can delete it | Excel Discussion (Misc queries) | |||
Password protect an Excel document | Excel Programming |