×
INTELLIGENT WORK FORUMS
FOR ENGINEERING PROFESSIONALS

Log In

Come Join Us!

Are you an
Engineering professional?
Join Eng-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Eng-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Jobs

password protected sheet

password protected sheet

password protected sheet

(OP)
I am creating some excel sheets for work and need to password protect them all. However I know there will be some people that will attempt to hack the file.

Is there a way that I can open the spreadsheet and see if someone has turned ever off the protection.....(I am assuming that they turned it off, made their changes, and turned it back on.)

RE: password protected sheet

I think you would have to do it with a macro.  The macro could be set to trigger on any of the sheet or workbook events and either make some small change somewhere that the hacker may or may not notice, or delete the whole sheet, reformat his hard drive, etc.

RE: password protected sheet

There are various flags that are set when the file is protected:

If ActiveWorkbook.ProtectStructure = True Then
    MsgBox "Remember, you cannot delete, add, or change " & _
        Chr(13) & _
        "the location of any sheets in this workbook."
End If

These are described in the help files.  One thing that you can do to make it more difficult for the thief is to remove all the copy and save commands from the menus and toolbars in your sheet.  You can also reassign the copy or save commands to run a macro that makes a permanent change or emails you or whatever.

TTFN

FAQ731-376: Eng-Tips.com Forum Policies


RE: password protected sheet

There is one thing about cracking passwords in Excel: you aren't going to find the original password, only one that gives the same "hash". So, if the workbook is no longer protected with your password, it has been opened and saved by someone else. Then again, you might never see the cracked copy, so you would need another method as suggested above.

Cheers,
Joerd

Please see FAQ731-376: Eng-Tips.com Forum Policies for tips on how to make the best use of Eng-Tips.

RE: password protected sheet

(OP)
Thanks for the advice. Would there be a better way to secure the file other than using excel's password?

RE: password protected sheet

If I wanted to hack a file, I would make a copy first. This way, I can hack at my leisure, and the originator wouldn't be bothered.

If you need to truely secure a file, Excel's password is not going to do it. I am not a security expert, so I would recommend you consult one if "security" is a real concern.

"Do not worry about your problems with mathematics, I assure you mine are far greater."   
Albert Einstein
Have you read FAQ731-376: Eng-Tips.com Forum Policies to make the best use of Eng-Tips Forums?

RE: password protected sheet

If the items to be secured are calculations, you have the possibility of creating an add-in to do the calculation, which is obviously quite involved.  Nonetheless, such an approach is portable and makes the protection much more inherent and robust.

TTFN

FAQ731-376: Eng-Tips.com Forum Policies


RE: password protected sheet

Excel password security is almost totally ineffective to any even slightly determined user. There are free/cheap crackers available everywhere. If you have concerns over Excel security there is a overview at http://www.codematic.net/Excel-development/Excel-dev-general/excel-security.htm

You can also use COM addins/XLLs for your calculations if you want to keep meddlers out - a quick google for 'xll microsoft' will take you to several info sources and examlpes

Good Luck
johnwm
________________________________________________________
To get the best from these forums read FAQ731-376: Eng-Tips.com Forum Policies before posting
Steam Engine enthusiasts
Steam Engine Prints

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Eng-Tips Forums free from inappropriate posts.
The Eng-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Eng-Tips forums is a member-only feature.

Click Here to join Eng-Tips and talk with other members!


Resources