| View previous topic :: View next topic |
| Author |
Message |
polecat
General User
Joined: 12 Mar 2007
Posts: 7
Location: Alberta, Canada
|
 Posted: Wed Mar 21, 2007 8:02 pm Post subject: Problem with Sheet Protection |
 |
|
I have protected all the cells in a worksheet and using Tools>Protect Document>Sheet have entered a password (twice) to lock the sheet.
When I close and re-open the document, I go to Tools>Protect Document and note that there is a check mark next to Sheet. On an inconsistent basis, if I simply click on Sheet, it unlocks the sheet without requiring me to enter the password.
I don't want my client fooling around with the formulas. What's my problem with sheet protection? Thanks. |
|
| Back to top |
|
 |
noranthon
Super User
Joined: 07 Jul 2005
Posts: 3318
|
| Posted: Wed Mar 21, 2007 8:11 pm Post subject: |
|
|
My guess is that you have saved the document as .xls. IIRC, that is regarded as an expected loss when using a foreign format.
_________________
search forum by month |
|
| Back to top |
|
|
polecat
General User
Joined: 12 Mar 2007
Posts: 7
Location: Alberta, Canada
|
| Posted: Thu Mar 22, 2007 3:44 am Post subject: |
|
|
Thanks, noranthon!
True, the file was saved as an .xls file. Would a 'workaround' be to re-save the document at the client's location using Excel?
Thanks. |
|
| Back to top |
|
|
|
