"Victor Lobo" wrote in message
news:op.unyrhv1zxzrtiv@victorisgod2...
On Sun, 18 Jan 2009 22:56:52 +0530, Bob Newman wrote:


"Victor Lobo" wrote in message
news:op.unylgz04xzrtiv@victorisgod2...
On Sun, 18 Jan 2009 20:33:12 +0530, Bob Newman
wrote:

d for full access including editin

Hi

When you try Format/Protect Sheet only the current sheet gets
protected/unprotected

Try this.

Open the file
Do a file save as.
In the dialog box select ToolsGeneral Options
Delete the passwords present there
Click Ok
Save the file
Close and open the file again

-- Thanks,
Victor

Using Opera's revolutionary e-mail client: http://www.opera.com/mail/

"In the dialog box select ToolsGeneral Options"

My Excel 2007 workbook does not offer a choice of Tools under Save As.
There is only the "Excel Options" box in the lower right which is
visible on anything you choose from the Office Button, it says nothing
about passwords. That is a general button for all Excel documents.

Bob


Ok, what I ment was this:

Assume your document is in the .xslx format

Do this:
1. Goto Save As
2. Select Excel Workbook (If your document is not in .xslx format you need
to select accordingly here)
3. In that dialog box select ToolsGeneral Options
4. Delete the passwords present there
5. Click Ok
6. Save the file
7. Close and open the file again


Hope this clarifies things

--
Thanks,
Victor

Using Opera's revolutionary e-mail client: http://www.opera.com/mail/

Thanks... That did the trick,

Bob