DeleteSetting Statement
Collapse the table of content
Expand the table of content
This documentation is archived and is not being maintained.

DeleteSetting Statement

This page is specific to the Visual Basic for Applications (VBA) Language Reference for Office 2010.

Deletes a section or key setting from an application's entry in the Windows registry or (on the Macintosh) information in the application's initialization file.


DeleteSetting appname, section[, key]

The DeleteSetting statement syntax has these named arguments:




Required. String expression containing the name of the application or project to which the section or key setting applies. On the Macintosh, this is the filename of the initialization file in the Preferences folder in the System folder.


Required. String expression containing the name of the section where the key setting is being deleted. If only appname and section are provided, the specified section is deleted along with all related key settings.


Optional. String expression containing the name of the key setting being deleted.


If all arguments are provided, the specified setting is deleted. A run-time error occurs if you attempt to use the DeleteSetting statement on a non-existent section or key setting.

The following example first uses the SaveSetting statement to make entries in the Windows registry (or .ini file on 16-bit Windows platforms) for the application, and then uses the DeleteSetting statement to remove them. Because no key argument is specified, the whole section is deleted, including the section name and all its keys.

' Place some settings in the registry. 
SaveSetting appname := "MyApp", section := "Startup", _ 
 key := "Top", setting := 75 
SaveSetting "MyApp","Startup", "Left", 50 
' Remove section and all its settings from registry. 
DeleteSetting "MyApp", "Startup"
© 2016 Microsoft