Removing Host Controls

Removing controls from a worksheet is usually straightforward. As with most controls, you can select the host control on the worksheet and then press the DELETE key. In the case of NamedRange controls, this isn't possible. Pressing DELETE deletes the contents of the control but not the control itself. Instead, you must use Excel's Define Name dialog box.

To delete the control, right-click the NamedRange and click Managed Named Ranges. In the Define Name dialog box, select the NamedRange you want to delete, and then click Delete, as shown in Figure 7.13.

Start Page Sheetl.vb* ExcdWDrkbookl.xls*

1 a S il"™1 -II10 »

H

aœ^^Ki nan

f.

First Name

-

I NamedRange 1 | OK

El- ExcelWorkbookl.xls

1

-

NamedRange2

Close |

]••• [|5l North windDataSet.xsd ]••• §1 My Project ]■■• O References ]••• bin ]■■■ D obj

Isi. ™fl„

2

3

Add

4

Delete |

5

First Name

6

Last Name

7

zl

8

9

_

|=5heetl!$B$5 ^J

1D 11

-

-

1

12

13

14

15

NamedRange 1 Microsoft. Off ice, Tool:

16

17

hKMr J

18

F

(DataBindings) ^

19

(Namfii NamprlRfinnpl

20

1 rnli.m^

Figure 7.13. Deleting a NamedRange control

Figure 7.13. Deleting a NamedRange control

0 0

Post a comment