MS Custom UI Editor - "File contains corrupted data"

[LibT]

VBA is messing with my head so I decided to customize the ribbon.

Problem is I cant open my xlsm file in the Microsoft Custom UI Editor, it says "File contains corrupted data"

How can I fix this?

Im thinking of copying all the sheets, Modules & User Forms BUT is there a chance I will be copying the corrupted data???

How can I be sure, as I wouldn't think the custom UI editor would be made to identify just any data corruption. I would think it would be limitied to what would effect the ribbon customizaton.

Thanks in advance, LibT

 

[LibT]

Update:
A straight copy (of sheets and export/import of modules & forms) does not fix this issue . Corruption copies too!

 

[LibT]

PROBLEM SOLVED:

I had the workbook protected

 

[wtoh]

protecting a workbook can be inevitable. in the event that workbook is protected and we got the "File contains corrupted data." error. any workarounds?

 

[jproffer]

That's......weird!! LOL, what I mean is...I have several WB's (add-in's actually) that I change/update/revamp pretty regularly with the custom UI editor, and they are all protected and I've never had a problem.

EDIT: The VBA projects are protected but I suppose the WB's themselves aren't. So maybe it's not so weird afterall

 

[LibT]

protecting a workbook can be inevitable. in the event that workbook is protected and we got the "File contains corrupted data." error. any workarounds?

unprotect the workbook!
is there any reason why you can't save the workbook after unprotecting then open in the custom UI editor, make changes, save, open in excel and put protection back on?

 

[wtoh]

Yeah, my error is for server side processing via open xml.
This error occurred when a protected workbook is not saved in open xml format. Attempt to process the file via open xml produce the "File contains corrupted data" error.

Not exactly a VBA issue. :x