Yes, but what if someone use copy, paste to floppy disc. In that way excel
is not pretected.

But what good does that do this person? Without the password he cannot open
the file because it is encrypted. It is true that there are programs that
break passwords but if you choose a truly random password like "2#fH^;l45xa"
the password breaker may have to work for years...

How does having a button on a worksheet that runs a macro protect a
workbook? _Any_ kind of protection scheme that involves macros is
inherently very weak. All you have to do is disable macros and it's gone.

--
Jim Rech
Excel MVP
"Hrvoje" wrote in message
...
| I think your only protection against someone opening the workbook would
be
| to use a password during File, Save As.
|
| Yes, but what if someone use copy, paste to floppy disc. In that way excel
| is not pretected.
| I am asking this as I've seen one excel file which is protected in one
way.
| I don't know how but is not working on my computer.
| It has excel file to enter data, and when you click button makes report in
| another excel file.
| I would like to have some protection in my excel, even in this way. Is
there
| some way that excel when opens checks folder from where is open, and if it
| is not in right directory doesn't work, or something similar.
|
| Thanks in advance
|
|