The protection is not secure at all. There are number of programs which will recover passwords from protected office documents. Just do a Google search for office password recovery, for some examples.
This is handy if you ever forget your passwords, but not so good for restricting access for others.