AllowFormattingCells Property
The document is archived and information here might be outdated

Protection.AllowFormattingCells Property 

Returns True if the formatting of cells is allowed on a protected worksheet.

Namespace: Microsoft.Office.Interop.Excel
Assembly: Microsoft.Office.Interop.Excel (in

Dim protection1 As Protection

Dim returnValue As Boolean
returnValue = protection1.AllowFormattingCells

bool AllowFormattingCells {get;}
public boolean get_AllowFormattingCells();
function get AllowFormattingCells() : Boolean;

The AllowFormattingCells property can be set by using the Protect method arguments.

Use of this property disables the protection tab, allowing the user to change all formats but not to unlock or unhide ranges.

Any public static (Shared in Visual Basic) members of this type are thread safe. Any instance members are not guaranteed to be thread safe.

Development Platforms

Windows XP Home Edition, Windows XP Professional, Windows Server 2003, and Windows 2000

Target Platforms

© 2016 Microsoft