Best way to protect sheets and document.

  • Thread starter Thread starter Luong
  • Start date Start date
L

Luong

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
 
Worksheets have an "EnableOutlining" property, which you would have to set
top True each time the workbook is opened.

--
Jim Rech
Excel MVP
| 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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Protection 2
best way protect unprotected cells 2
password protect individual sheets 1
Enable groups on a protected sheet 4
Protected Sheet and grouping 1
Protecting cell contents 3
Working with protected files... 4
Format columns and cells in a protected sheet 2

Back
Top