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.)
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
RE: password protected sheet
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
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
RE: password protected sheet
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
TTFN
FAQ731-376: Eng-Tips.com Forum Policies
RE: password protected sheet
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
RE: password protected sheet
http://www.gold-software.com/download9409.html