Password Protect Excel 2000 (Excel 2000)

Topic

New Reply

One of my colleagues has developed a spreadsheet with macros written in VB and others recorded to perform some quite complex analysis.

He has password protected the workbook but the file needs to be sent out on a CD ROM and saved onto another network. This results in the password protection being lost thus allowing anybody, even unwittingly, to mess it up. Is there anyway around this?

The only idea around this so far is to have the new users save the file as a template, so if they make a pig’s ear of it, they can start again.

If this is the solution, is it possible to get the CD ROM to place the file in their template folder without the normal Excel user easily redirecting the file when they copy it from the CD.

Reply | Quote

Replies

AFAIK copying the file to a CD would not change the password protection in any way.

Excel has a number of passwords that can be set:

– password protected worksheet(s)
– password protected Workbook
– File open password
– File modify password
– password to unhide/edit the VBA code

Which is the one you’re afraid of loosing?

Reply | Quote

Password to modify. If the Excel workbook is copied from the CD to a pc, the password to modify disappears. It seems to perform a Save As type function.

If he ZIPs the file and then extracts it from the CD to the pc the password to modify remains. . Send out a CD with the file as a self extracting ZIP? But I think we need to understand what is going on.

What he doesn’t want to happen is someone to be able to overwrite the original Master file, so to speak. The users of the workbook will have very little Excel experience. They will just fill in the information, press a few buttons the macros etc will generate the analysis and a report.

Reply | Quote

Obviously it is the method that is being used to put the file on CD that is the culprit. I’d suggest :

– save the file as usual (passwords in place and all).
– Then close Excel
– open Windows Explorer (or your CD burning program)
– copy the file to CD or first ZIP it (recommended) and then copy it

Reply | Quote

I have passed this information on and this seems to be the solution.

Thanks to everyone for their help.

Reply | Quote

File system passwords are dependent on the file system understanding the password mechanism used by the originating file system. Has nothing to do with Excel.

Excel VBA does allow one to password protect a project, but unethical peopke will purchase, or already have, password crackers. How good are the crackers? I dunno.

Another alternative is to create a COM addin using either Office 2000 Developer or Office XP Developer, as the compiled DLLs are fairly secure.

Reply | Quote

The password crackers for WB and WS protection work all too well. The File, Open password protection available in Excel is more robust, and I think only expensive commercial Crackers work on the VBE protection.

Reply | Quote

What are “WB” and “WS”?

The VBE crackers are not that expensive, but I do not know how well they work.
Heck, if somebody wants to rip-off code, spending even a few hundred dollars for a cracker just ain’t much compared to the cost of writin t ecode.

In VS .NET, there is no way to protect managed code.
You have to obfuscate, but all that does is make it more expensive for someone to figure out the code.

Reply | Quote

WB = Workbook, WS = Worksheet. Excel has built in protection for Open, Workbook, Worksheet and VBE. Oops, and as Jan Karel noted, Modify.

Reply | Quote

WB is shortcut for Workbook.
WS is shortcut for Worksheet.
In John’s context they are the standard “protection” available from tools – protection (protect sheet / protect workbook)

Steve

Reply | Quote

Password crackers for Excel VBA work very well and pretty much instataneously.
Drag an Excel file (containing a password protected project) from Explorer into the ‘uncrack’ box and you will get a password to unlock the project.
Also, from what I have seen the actual password used for protection is not necessarily unique, i.e. a password given to unlock may actually be different to what was used to protect it.

zeddy

Reply | Quote