Adjust the new Controls properties

In this case, I changed only one property: Caption.

Figure 20-4:

A new menu, called Budgeting, was added to this menu bar.

Microsoft Excel add new menu.xls

- "

!i] File Edit View

Insert Format Tools Data Window Budgeting Help

_ s

X

i 1 ? a^^^ ^jaLŒLjjLiàj

1- Ï •

ti una-A™» • *.

: Añal

- 10

- s i a s

"I

% % ' too -iS£ I

E1D

f.

A

B

C 1 D

E

F G

H

] J

K

E

1

2

3

4

5

The preceding procedure uses the Add method, with three named arguments:

1 Type: Identifies the type of control. (msoControlPopup is a built-in constant.)

1 Before: Identifies the position on the menu bar. I determined the position of the Help menu and assigned it to the variable HelpIndex.

1 Temporary: This argument is True, so the menu change is not permanent. In other words, the Budgeting menu doesn't appear when you restart Excel.

0 0

Post a comment