ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Unprotecting a Workbook in Excel 2003 (https://www.excelbanter.com/excel-discussion-misc-queries/173271-unprotecting-workbook-excel-2003-a.html)

wolvina

Unprotecting a Workbook in Excel 2003
 
Hi All! I need to unprotect (forever) a workbook in Excel 2003. I've
tried doing what Help says (Tools Protect Unprotect Workbook); however,
no matter whether I save the document, or resave as a new document, the file
keeps coming up as either a read only or as a password protected documented.
I need it to be just a regular ole document!!

Thanks for any help!!



Dave Peterson

Unprotecting a Workbook in Excel 2003
 
There are lots of levels of protection in excel.

worksheet protection (tools|protection|protect sheet)
workbook protection (tools|Protection|protect workbook)

and at least one mo

File|SaveAs|Tools|General Options|Password to open (and password to modify)

It sounds like you really want the last one.

wolvina wrote:

Hi All! I need to unprotect (forever) a workbook in Excel 2003. I've
tried doing what Help says (Tools Protect Unprotect Workbook); however,
no matter whether I save the document, or resave as a new document, the file
keeps coming up as either a read only or as a password protected documented.
I need it to be just a regular ole document!!

Thanks for any help!!


--

Dave Peterson

Marcelo

Unprotecting a Workbook in Excel 2003
 
hi,

try to check if the read only recommended on the save options pressing F12
or file save as, click on Tools General Options.

hth
--
regards from Brazil
Thanks in advance for your feedback.
Marcelo



"wolvina" escreveu:

Hi All! I need to unprotect (forever) a workbook in Excel 2003. I've
tried doing what Help says (Tools Protect Unprotect Workbook); however,
no matter whether I save the document, or resave as a new document, the file
keeps coming up as either a read only or as a password protected documented.
I need it to be just a regular ole document!!

Thanks for any help!!




All times are GMT +1. The time now is 12:36 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com