| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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. |
|
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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. |
|
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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. |
|
#5
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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. |
|
#6
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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. |
|
#7
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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! |
|
#8
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Linked text boxes created in Excel 2007 are blank in Excel 2003? | Charts and Charting in Excel | |||
| Excel - unprotect certain cells in protected sheet/workbook | Excel Discussion (Misc queries) | |||
| how do I unprotect an excel spreadsheet in beta 2007 | Excel Discussion (Misc queries) | |||
| unable to unprotect my protected excel file | Excel Discussion (Misc queries) | |||
| Unable to unprotect a protected excel file | Excel Discussion (Misc queries) | |||
Linear Mode
