Click Reset to restore the Worksheet menu bar to its default state

Figure 20-1:

The worksheet menu bar after zapping the Help menu.

x] Microsoft Excel - Bookl

: 3J File Edit View insert Format look Data Windoi

Type a quesbon For help

- 0SB

-i .. ..

^ E -

nil i:

ioo%

: Ariaf

a 10

- B i n | m

mmm

S %

jo ¿S

H20

r>

A

B

c

D

E

F

G

H 1 1

J

K —

1

2

3

4

5

P

I think Microsoft made it far too easy to mess up your menus. My advice? Don't use the ViewOToolbarsOCustomize command to change menus. In almost every case, you want your menu modifications to be in effect only when a particular workbook is open. To do that, you need to use VBA to make your menu changes — which is the topic of this chapter.

Refer to Chapter 19 for details regarding the Customize dialog box. The procedures that I describe for toolbars also work for menu bars.

0 0

Post a comment