unprotect (in Excel 2007) workbook created and protected in Excel
 

When I open (in Excel 2007) a workbook created and protected in Excel 2003, I
cannot unprotect it. When I go to the Review tab, the Changes block of the
ribbon shows an icon to "Protect Workbook" (as though the workbook were not
protected) rather than one to "Unprotect Workbook". I have not been able to
find anything in Help to suggest another approach/method.

The workbook was protected in Excel 2003 using both the Structure and
Windows options.

unprotect (in Excel 2007) workbook created and protected in Excel
 

Hi DonJ

The label of the button will not change if the workbook is protected
Click on the arrow on the button and choose "Protect Structure and Windows"
You see it checked or unchecked

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"DonJ_Austin" wrote in message ...
When I open (in Excel 2007) a workbook created and protected in Excel 2003, I
cannot unprotect it. When I go to the Review tab, the Changes block of the
ribbon shows an icon to "Protect Workbook" (as though the workbook were not
protected) rather than one to "Unprotect Workbook". I have not been able to
find anything in Help to suggest another approach/method.

The workbook was protected in Excel 2003 using both the Structure and
Windows options.

unprotect (in Excel 2007) workbook created and protected in Ex
 

Actually, I got the answer to my problem (which was again an issue of
fundamental changes in UI in Office 2007 that are not always intuitive) from
a local colleague.

Thanks for the reply. I am *sure* I'll be back to this group with similar
challenges in adpating to the new UI.

Cheers. dj

"Ron de Bruin" wrote:

Hi DonJ

The label of the button will not change if the workbook is protected
Click on the arrow on the button and choose "Protect Structure and Windows"
You see it checked or unchecked

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"DonJ_Austin" wrote in message ...
When I open (in Excel 2007) a workbook created and protected in Excel 2003, I
cannot unprotect it. When I go to the Review tab, the Changes block of the
ribbon shows an icon to "Protect Workbook" (as though the workbook were not
protected) rather than one to "Unprotect Workbook". I have not been able to
find anything in Help to suggest another approach/method.

The workbook was protected in Excel 2003 using both the Structure and
Windows options.

unprotect (in Excel 2007) workbook created and protected in Ex
 

I am having the same issue. How did you resolve it?
-Jeff

"DonJ-Austin" wrote:

Actually, I got the answer to my problem (which was again an issue of
fundamental changes in UI in Office 2007 that are not always intuitive) from
a local colleague.

Thanks for the reply. I am *sure* I'll be back to this group with similar
challenges in adpating to the new UI.

Cheers. dj

"Ron de Bruin" wrote:

Hi DonJ

The label of the button will not change if the workbook is protected
Click on the arrow on the button and choose "Protect Structure and Windows"
You see it checked or unchecked

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"DonJ_Austin" wrote in message ...
When I open (in Excel 2007) a workbook created and protected in Excel 2003, I
cannot unprotect it. When I go to the Review tab, the Changes block of the
ribbon shows an icon to "Protect Workbook" (as though the workbook were not
protected) rather than one to "Unprotect Workbook". I have not been able to
find anything in Help to suggest another approach/method.

The workbook was protected in Excel 2003 using both the Structure and
Windows options.

unprotect (in Excel 2007) workbook created and protected in Ex
 

Hi Jeff

Do you have arrow on the Protect workbook option in the Ribbon so you can open the Menu ?


--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Jeff" wrote in message ...
I am having the same issue. How did you resolve it?
-Jeff

"DonJ-Austin" wrote:

Actually, I got the answer to my problem (which was again an issue of
fundamental changes in UI in Office 2007 that are not always intuitive) from
a local colleague.

Thanks for the reply. I am *sure* I'll be back to this group with similar
challenges in adpating to the new UI.

Cheers. dj

"Ron de Bruin" wrote:

Hi DonJ

The label of the button will not change if the workbook is protected
Click on the arrow on the button and choose "Protect Structure and Windows"
You see it checked or unchecked

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"DonJ_Austin" wrote in message
...
When I open (in Excel 2007) a workbook created and protected in Excel 2003, I
cannot unprotect it. When I go to the Review tab, the Changes block of the
ribbon shows an icon to "Protect Workbook" (as though the workbook were not
protected) rather than one to "Unprotect Workbook". I have not been able to
find anything in Help to suggest another approach/method.

The workbook was protected in Excel 2003 using both the Structure and
Windows options.

unprotect (in Excel 2007) workbook created and protected in Ex
 

Hi DonJ,

How did you resolve the issue? I am encountering the same problem.

Thanks!

Jun

"DonJ-Austin" wrote:

Actually, I got the answer to my problem (which was again an issue of
fundamental changes in UI in Office 2007 that are not always intuitive) from
a local colleague.

Thanks for the reply. I am *sure* I'll be back to this group with similar
challenges in adpating to the new UI.

Cheers. dj

"Ron de Bruin" wrote:

Hi DonJ

The label of the button will not change if the workbook is protected
Click on the arrow on the button and choose "Protect Structure and Windows"
You see it checked or unchecked

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"DonJ_Austin" wrote in message ...
When I open (in Excel 2007) a workbook created and protected in Excel 2003, I
cannot unprotect it. When I go to the Review tab, the Changes block of the
ribbon shows an icon to "Protect Workbook" (as though the workbook were not
protected) rather than one to "Unprotect Workbook". I have not been able to
find anything in Help to suggest another approach/method.

The workbook was protected in Excel 2003 using both the Structure and
Windows options.

unprotect (in Excel 2007) workbook created and protected in Ex
 

On Aug 21, 2:52*am, JunGanzon
wrote:
Hi DonJ,

How did you resolve the issue? *I am encountering the same problem.

Thanks!

Jun

"DonJ-Austin" wrote:
Actually, I got the answer to my problem (which was again an issue of
fundamental changes in UI in Office 2007 that are not always intuitive) from
a local colleague.

Thanks for the reply. *I am *sure* I'll be back to this group with similar
challenges in adpating to the new UI.

Cheers. * * dj

"Ron de Bruin" wrote:

Hi DonJ

The label of the button will not change if the workbook is protected
Click on the arrow on the button and choose "Protect Structure and Windows"
You see it checked or unchecked

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm

"DonJ_Austin" wrote in ...
When I open (in Excel 2007) a workbook created and protected in Excel 2003, I
cannot unprotect it. *When I go to the Review tab, the Changes block of the
ribbon shows an icon to "Protect Workbook" (as though the workbook were not
protected) rather than one to "Unprotect Workbook". *I have not been able to
find anything in Help to suggest another approach/method.

The workbook was protected in Excel 2003 using both the Structure and
Windows options.

Same problem here. Any tips?

Thanks!

unprotect (in Excel 2007) workbook created and protected in Ex
 

Hi Jun

Do you have arrow on the Protect workbook option in the Ribbon so you can open the Menu ?

Can you send me the file private, I like to see it.

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


wrote in message ...
On Aug 21, 2:52 am, JunGanzon
wrote:
Hi DonJ,

How did you resolve the issue? I am encountering the same problem.

Thanks!

Jun

"DonJ-Austin" wrote:
Actually, I got the answer to my problem (which was again an issue of
fundamental changes in UI in Office 2007 that are not always intuitive) from
a local colleague.

Thanks for the reply. I am *sure* I'll be back to this group with similar
challenges in adpating to the new UI.

Cheers. dj

"Ron de Bruin" wrote:

Hi DonJ

The label of the button will not change if the workbook is protected
Click on the arrow on the button and choose "Protect Structure and Windows"
You see it checked or unchecked

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm

"DonJ_Austin" wrote in
...
When I open (in Excel 2007) a workbook created and protected in Excel 2003, I
cannot unprotect it. When I go to the Review tab, the Changes block of the
ribbon shows an icon to "Protect Workbook" (as though the workbook were not
protected) rather than one to "Unprotect Workbook". I have not been able to
find anything in Help to suggest another approach/method.

The workbook was protected in Excel 2003 using both the Structure and
Windows options.

Same problem here. Any tips?

Thanks!