LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #6   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 6
Default I would want protect my sheets of excel from a "password recov

Sorry Luca

Don't know anything about excel2007. I don't know of any secure workbooks,
but if there are any they are probably designed for accounting systems and
whoever you were emailing the workbook to may need that same software. If
the data is very sensitive a pdf may be the only way. If it is code or
formulas you are worried about, your best bet may be to save a copy of the
workbook as "value only" so there will be no formulas and removing any
code/modules. Just make sure to save a copy first before making the changes.
Never alter an original.

good luck
George

"-= Luca =-" wrote:


"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



 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Add "Protect ALL Sheets" that is the same as "Protect Sheet" KLLuoma Excel Worksheet Functions 0 July 27th 06 07:55 PM
OT I would want protect my sheets of excel from a "password recovery" software... How? -= Luca =- Excel Worksheet Functions 3 May 31st 06 10:11 AM
ActiveWorkbook.Protect password:=range("rangename") does not work WimR Excel Programming 2 June 26th 05 08:47 AM
How to crack "Protect Sheet" Password in Excel? Hardik Shah[_2_] Excel Programming 4 May 15th 05 02:23 PM
no password carryover with "protect sheet" in macro Trevor Shuttleworth Excel Programming 0 February 12th 04 09:44 PM


All times are GMT +1. The time now is 02:57 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"