Fluent UI and protect workbook with password

[Nick]

This issue has to deal with adding a Fluent UI tab according to the
procedures at: http://msdn.microsoft.com/en-us/library/aa338202.aspx

The section I’m referring to is under the title: “To customize the Fluent
UI by using Office Open XML Formats files“.

This works according to article, however, if we go to Protect Workbook -->
check the box next to Structure --> add a password --> save the document -->
close the document --> follow the procedures in the MSDN article in order to
make modifications to the Fluent UI using Office Open XML Formats. Once you
add the .ZIP extension to the end of the file name, we get an error when
trying to open the zip file.

Title: Compressed (zipped) Folders Error
Msg: The Compressed (zipped) Folder is invalid or corrupted.

I have tried this similar case in Word 2007, but do not receive any error,
so it is particular to Excel 2007.

We are currently using Windows XP SP2 with Office 2007 Pro Plus, and I have
tried this on Windows Vista Business with Office 2007 Pro Plus to determine
if it is an OS issue, but received the same outcome so we feel it is a bug in
Excel 2007 and the MSDN article.

Thank you in advance for your attention to this possible bug in the Excel
application. Please let us know any results/fixes/questions you may have.

 

[Jim Rech]

A structure protected workbook is encrypted when it is saved by Excel and no
longer a zip file. You must unprotect it in order to manipulate its parts.

--
Jim
| This issue has to deal with adding a Fluent UI tab according to the
| procedures at: http://msdn.microsoft.com/en-us/library/aa338202.aspx
|
| The section I'm referring to is under the title: "To customize the Fluent
| UI by using Office Open XML Formats files".
|
| This works according to article, however, if we go to Protect Workbook -->
| check the box next to Structure --> add a password --> save the
document -->
| close the document --> follow the procedures in the MSDN article in order
to
| make modifications to the Fluent UI using Office Open XML Formats. Once
you
| add the .ZIP extension to the end of the file name, we get an error when
| trying to open the zip file.
|
| Title: Compressed (zipped) Folders Error
| Msg: The Compressed (zipped) Folder is invalid or corrupted.
|
| I have tried this similar case in Word 2007, but do not receive any error,
| so it is particular to Excel 2007.
|
| We are currently using Windows XP SP2 with Office 2007 Pro Plus, and I
have
| tried this on Windows Vista Business with Office 2007 Pro Plus to
determine
| if it is an OS issue, but received the same outcome so we feel it is a bug
in
| Excel 2007 and the MSDN article.
|
| Thank you in advance for your attention to this possible bug in the Excel
| application. Please let us know any results/fixes/questions you may have.
|
| --
| Nick

 

[Nick]

Thanks for the reply Jim.

Do you know why this behavior is allowed in Word 2007, when password
protecting, and doesn't have the same restriction as Excel 2007?

 

[Jim Rech]

It's a good question why structure protecting a workbook leads to encrypting
in Excel 2007 when it didn't in Excel 2003 (or Word as you say). I haven't
seen an explanation from MS on this. It used to be that only a File, Save
password added encryption. I guess MS could say it makes it harder for
someone to turn off structure protection by editing the file with a hex or
XML editor but the same could be said for sheet protection which does not
lead to encryption. I'm sure there's some logic there but we may never know
it.

--
Jim
| Thanks for the reply Jim.
|
| Do you know why this behavior is allowed in Word 2007, when password
| protecting, and doesn't have the same restriction as Excel 2007?
| --
| Nick
|
|
| "Jim Rech" wrote:
|
| > A structure protected workbook is encrypted when it is saved by Excel
and no
| > longer a zip file. You must unprotect it in order to manipulate its
parts.
| >
| > --
| > Jim
| > | > | This issue has to deal with adding a Fluent UI tab according to the
| > | procedures at: http://msdn.microsoft.com/en-us/library/aa338202.aspx
| > |
| > | The section I'm referring to is under the title: "To customize the
Fluent
| > | UI by using Office Open XML Formats files".
| > |
| > | This works according to article, however, if we go to Protect
Workbook -->
| > | check the box next to Structure --> add a password --> save the
| > document -->
| > | close the document --> follow the procedures in the MSDN article in
order
| > to
| > | make modifications to the Fluent UI using Office Open XML Formats.
Once
| > you
| > | add the .ZIP extension to the end of the file name, we get an error
when
| > | trying to open the zip file.
| > |
| > | Title: Compressed (zipped) Folders Error
| > | Msg: The Compressed (zipped) Folder is invalid or corrupted.
| > |
| > | I have tried this similar case in Word 2007, but do not receive any
error,
| > | so it is particular to Excel 2007.
| > |
| > | We are currently using Windows XP SP2 with Office 2007 Pro Plus, and I
| > have
| > | tried this on Windows Vista Business with Office 2007 Pro Plus to
| > determine
| > | if it is an OS issue, but received the same outcome so we feel it is a
bug
| > in
| > | Excel 2007 and the MSDN article.
| > |
| > | Thank you in advance for your attention to this possible bug in the
Excel
| > | application. Please let us know any results/fixes/questions you may
have.
| > |
| > | --
| > | Nick
| >
| >
| >