View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
-= Luca =- -= Luca =- is offline
external usenet poster
 
Posts: 5
Default I would want protect my sheets of excel from a "password recovery"


"georgesmailuk" ha scritto nel
messaggio ...
Luca - there is no way i know of protecting excel. It was never designed

for
real security. You could make it harder for people to get the

infromation,
but the only thing i can think of (i tried this a long time ago and gave

up
because i was not sure i could recover the data) is to write a macro that
will scramble your data so that it is unreadable, and unless the correct
password is entered, closes down. This is risky though. You could lose

your
entire workbook if someone tries to tamper with it and you don't have a
backup.

Even the VBA password can be bypassed with a Hex editor.

If you are sending the workbook to someone and you only want them to view
the pages, i would make it into a pdf file and not give them the workbook

at
all. Something free like pdf995 could do this.

Sorry there is no better news.
George


:-( Do you know if there are another WB designed for real sicurity (maybe
openoffice or other?)
Also i have ear that the next excel 2007 could have a better protection, do
you know something?

Thank's
Luca