Programmatically remove custom properties

[kpnekvasil]

Has anyone ever removed custom properties using VBA? We have drawings that we create for customers that have a lot built in custom properties. We want to give them the drawings so they can edit later but we don't want them to have all the background work we have done via the custom properties. Any thoughts?

[aledlund]

I know it's come up before. It's merely selecting the custom property section, get the count of rows and then remove them starting at the back and moving to the front.

http://msdn.microsoft.com/en-us/library/office/aa224575(v=office.11).aspx

al

[Yacine]

further to al's answer, you might want to identify your shapes by means of an ID stored in the user section, so you can restore the custom properties, once you get them updated back from your customers.

[kpnekvasil]

Thank you for the link!

Basically we don't want our end customer to have the custom data and infrastructure behind it. We have multiple things going on such as altering shape size/look/color, formulas and a few other things. Once we create drawings for the customer we don't want them to have that capability in the drawing we send them.

[Paul Herber]

 ... or just delete the entire section in one go ...
http://msdn.microsoft.com/en-us/library/office/aa224576%28v=office.11%29.aspx

Be aware though that deleting the cell/row/section may break the shape. Any formulae that reference the custom properties will no longer work correctly.