View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Luong[_2_] Luong[_2_] is offline
external usenet poster
 
Posts: 3
Default 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