Missing "Unprotect Workbook" option

[Paddler4x]

I have an Excel 2003 workbook I created a while back and applied protection
to it so a password must be entered to open it. I made a copy of the doc
with different name that I am trying to unprotect to transfer to a Windows
Mobile Smartphone so that I can open it on it, will not allow protected
documents to be viewed. So I followed the following steps:

Open the protected workbook.
On the Tools menu, point to Protection, and then click Unprotect Workbook.

HOWEVER, there is no unprotect option. How do I remove protection on this
document copy.

 

[dlw]

the one you are looking for in on the "save as" screen Tools/General Options

 

[Jim Rech]

If you saved the workbook with a password using File, Save you must do a
File, Save again and remove/backspacing over the password in the General
Options dialog.

--
Jim
|I have an Excel 2003 workbook I created a while back and applied protection
| to it so a password must be entered to open it. I made a copy of the doc
| with different name that I am trying to unprotect to transfer to a Windows
| Mobile Smartphone so that I can open it on it, will not allow protected
| documents to be viewed. So I followed the following steps:
|
| Open the protected workbook.
| On the Tools menu, point to Protection, and then click Unprotect Workbook.
|
| HOWEVER, there is no unprotect option. How do I remove protection on this
| document copy.

 

[Paddler4x]

Thank you DLW, it worked! Your directions were short, to the point and
WORKED! After doing so, I transfered the doc onto my Windows Mobile
Smartphone and had no problem viewing it. I went back to the original file
on my laptop, followed your directions and put back the password on the
original file. I am a happy camper.

Excellent!

Paddler4x

 

[Paddler4x]

Thank you Jim, your reply helped also - I am good to go! Made a physical
note to remember this in case I foget in the future (smile).

Paddler4x