ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   How can I open a protected 2003 spreadsheet with Office 2007 (https://www.excelbanter.com/excel-discussion-misc-queries/171331-how-can-i-open-protected-2003-spreadsheet-office-2007-a.html)

Mehdi

How can I open a protected 2003 spreadsheet with Office 2007
 
I have just had Microsoft Office 2007 edition installed and dont know how to
unprotect my 2003 Excel workbook. Any ideas?

Bob Phillips

How can I open a protected 2003 spreadsheet with Office 2007
 
Do you mean unprotect a worksheet? That can be found in the Format button in
the Cells group in the Home tab. Just click the dropdown at the bottom of
the button.

--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)



"Mehdi" wrote in message
...
I have just had Microsoft Office 2007 edition installed and dont know how
to
unprotect my 2003 Excel workbook. Any ideas?




Jim May

How can I open a protected 2003 spreadsheet with Office 2007
 
Sub ToUnprotectWB()
'
ActiveWorkbook.Unprotect Password:="password" ' if pw has been assigned
End Sub

"Mehdi" wrote:

I have just had Microsoft Office 2007 edition installed and dont know how to
unprotect my 2003 Excel workbook. Any ideas?


Willem Nel

How can I open a protected 2003 spreadsheet with Office 2007
 
How do I unprotect a protected form downloaded from the online templates in
office 2007. See boo-keeping form under forms on online templates.
--
Wllem Nel


"Jim May" wrote:

Sub ToUnprotectWB()
'
ActiveWorkbook.Unprotect Password:="password" ' if pw has been assigned
End Sub

"Mehdi" wrote:

I have just had Microsoft Office 2007 edition installed and dont know how to
unprotect my 2003 Excel workbook. Any ideas?



All times are GMT +1. The time now is 03:50 AM.

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