Workbook.RemoveCustomization Method

Removes the customization that was created by using Office development tools in Visual Studio from the workbook.

Namespace:  Microsoft.Office.Tools.Excel
Assembly:  Microsoft.Office.Tools.Excel (in Microsoft.Office.Tools.Excel.dll)

Syntax

'Declaration
Sub RemoveCustomization
void RemoveCustomization()

Exceptions

Exception Condition
CannotRemoveCustomizationException

The custom document properties or the cached data could not be removed from the workbook.

UnauthorizedAccessException

The document is protected.

Remarks

This method removes the customization by performing the following tasks:

  • It deletes the _AssemblyName and _AssemblyLocation custom properties from the workbook. For more information, see Custom Document Properties Overview.

  • It deletes the cached data from the workbook. For more information about cached data, see Caching Data.

This method might throw an UnauthorizedAccessException if the workbook is protected. You should remove any protection from the workbook before calling this method.

.NET Framework Security

See Also

Reference

Workbook Interface

Microsoft.Office.Tools.Excel Namespace

Other Resources

How to: Remove Managed Code Extensions from Documents

Caching Data

Custom Document Properties Overview