View Single Post
  #7   Report Post  
Posted to microsoft.public.excel.programming
arno arno is offline
external usenet poster
 
Posts: 184
Default Hiding Named Ranges

Hi,

again, it is clear that someone who knows vba can do whatever he likes with
office files, however, the average user does not even know what a macro is.
We can assume that we use alle the possibilities office gives us to hide and
protect knowing that it is not absolutely secure. So, do not use office
files to store secret data like real important passwords.

Hiding/protecting names, sheets, vba-code, formulas is all that can be
done, and this will for sure lock out 99% of users because they are simply
not skilled enough. Another 0.9% are administrators who have access to
everything anyway.

A password on the VBA-Modules does not help at all, eg
Sub test()
ActiveWorkbook.Sheets(1).Visible = True
End Sub
shows a very hidden sheet from a "protected" file.

regards

arno