View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.newusers
Ron de Bruin Ron de Bruin is offline
external usenet poster
 
Posts: 11,123
Default 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!