Select

f$.$ Select all six controls and align them on the right.

g$.$ Right$-$click the control in cell $C7$ and change the Cell link

to cell $$B$$$7.$

h$.$ Edit the linked cell for each of the controls.

i$.$ Delete any values that display in column B$.$

Insert a list box form control.

a$.$ Display the Developer tab on the Ribbon if it is not shown.

b$.$ Select cell E$2$ and unlot.k it$.$ This will be the linked cell for

the control.

c$.$ Draw a list box control to cover cells E$2$:F$2.$

d$.$ Format the control to use the list on the Data sheet and

assign cell E$2$ as the linked cell.

Figure $7-86$ Copied spin button form controls

e$.$ Verify that the Selection type is Single.

f$.$ Deselect the Locked property on the Protection tab. This unlocks the actual control.

g$.$ Size the control to reach row $4($Figure $7-87).$

h$.$ Select cell A$3.$

Unlock cells and protect a sheet.

a$.$ Select cells B$5,$ B$7,$ B$9,$ B$11,$ B$13,$

and B$15$ and unlock them.

b$.$ Mark the logo on the Daily sheet as

decorative.

c$.$ Select cell B$5$ and protect the Daily

sheet without a password.

Select Wednesday in the list box

Figure $7-97$ List box form control

control.