ControlSite Interface

Reference

Definition

Namespace:: Microsoft.Office.Tools.Excel

Assemblies:: Microsoft.Office.Tools.Excel.dll, Microsoft.Office.Tools.Excel.v4.0.Utilities.dll

Important

Some information relates to prerelease product that may be substantially modified before it’s released. Microsoft makes no warranties, express or implied, with respect to the information provided here.

Represents a linked or embedded control on a worksheet.

public interface class ControlSite : IDisposable

[System.Runtime.InteropServices.Guid("D7A3AD16-D044-4CDF-989D-AF46A924F1D8")]
public interface ControlSite : IDisposable

[<System.Runtime.InteropServices.Guid("D7A3AD16-D044-4CDF-989D-AF46A924F1D8")>]
type ControlSite = interface
    interface IDisposable

Public Interface ControlSite
Implements IDisposable

Attributes: GuidAttribute

Implements: IDisposable

Remarks

A ControlSite is returned when you use the AddControl method to add a control to a document. For more information, see Adding Controls to Office Documents at Run Time.

Note

This interface is implemented by the Visual Studio Tools for Office runtime. It is not intended to be implemented in your code. For more information, see Visual Studio Tools for Office Runtime Overview.

Properties

AltHTML
Application	Gets the creator of the ControlSite.
AutoLoad	Gets or sets a value that indicates whether the ControlSite is automatically loaded when the workbook that contains it is opened.
AutoUpdate	Gets or sets a value that indicates whether the ControlSite is updated automatically when the source changes.
Border	Gets the border of the ControlSite.
BottomRightCell	Gets a Range that represents the cell that lies under the lower-right corner of the ControlSite.
Creator	Gets a value that indicates the application in which the ControlSite was created.
Enabled	Gets or sets a value that indicates whether the ControlSite is enabled.
Height	Gets or sets the height, in points, of the ControlSite.
Index	Gets the index number of the ControlSite within the collection of similar objects.
Interior	Gets the interior of the ControlSite.
Left	Gets or sets the distance, in points, from the left edge of the ControlSite to the left edge of column A (on a worksheet) or the left edge of the chart area (on a chart).
LinkedCell	Gets or sets a value that identifies the range linked to the value of the ControlSite.
ListFillRange	Gets or sets a value that identifies the range used to fill the specified list box.
Locked	Gets or sets a value that indicates whether the ControlSite is locked.
Name	Gets or sets the name of the ControlSite.
Object	Gets the OLE Automation object associated with the ControlSite.
OLEType	Gets the ControlSite type.
OnAction
Parent	Gets the parent object for the ControlSite.
Placement	Gets or sets a value that indicates how the ControlSite is attached to the cells below it.
PrintObject	Gets or sets a value that indicates whether the ControlSite is printed when the document is printed.
progID	Gets the programmatic identifier for the ControlSite.
Shadow	Gets or sets a value that indicates whether the font is a shadow font or if the ControlSite has a shadow.
ShapeRange	Gets a ShapeRange that represents the specified ControlSite.
SourceName	Gets or sets the link source name of the ControlSite.
Top	Gets or sets the distance, in points, from the top edge of the ControlSite to the top of row 1 (on a worksheet) or the top of the chart area (on a chart).
TopLeftCell	Gets a Range that represents the cell that lies under the upper-left corner of the ControlSite.
Visible	Gets or sets a value that indicates whether the ControlSite is visible.
Width	Gets or sets the width, in points, of the ControlSite.
ZOrder	Gets the z-order position of the ControlSite.

Methods

Activate()	Activates the ControlSite.
BringToFront()	Brings the ControlSite to the front of the z-order.
Copy()	Copies the ControlSite to the Clipboard.
CopyPicture(XlPictureAppearance, XlCopyPictureFormat)	Copies the ControlSite to the Clipboard as a picture.
Cut()	Cuts the ControlSite to the Clipboard.
Delete()	Deletes the ControlSite.
Duplicate()	Duplicates the ControlSite and returns a reference to the new copy.
Select(Object)	Selects the ControlSite.
SendToBack()	Sends the ControlSite to the back of the z-order.
Update()	Updates the link.
Verb(XlOLEVerb)	Sends a verb to the server of the ControlSite.

Applies to

Freigeben über