Customizing shortcut menus

Excel 2007 still allows the VBA developer to customize the right-click shortcut menus. Figure 6-1 shows a customized shortcut menu that appears when you right-click a row number. Notice that this shortcut menu has six menu items (at the bottom) that aren't normally available.

* e c. a

E F G

H

|

1

-

2

C.U.

" -111 A" A1 t - % * J

n

t A n

*

iyf

i ■

*

i°w

t

Ml

fcarl

QdcU

Ow Contois

Emmrtldlk.

BJnHti^fl..

tfdf

Jfrch*

Fmri teli rlic^

leffk VVpid Artp

LhLn^eLdK * ;

Synchronic ShflifT

ToggkPUP DricPk-hcr T«*w

4 (Hi

•m.

Tejjif iuitifsEd Tmxbtr

29 | i i

<■ Shwti

_>_

Figure 6-1: An example of a customized shortcut menu.

Figure 6-1: An example of a customized shortcut menu.

CROSS- Chapter 23 describes how to work with shortcut menus using VBA.

REFERENCE

0 0

Post a comment