Download Unit 1

Unit 3 – Spreadsheet Design
• Click OK.
Whatever actions you perform will now be recorded and the Stop Recording toolbar is
displayed.
• Click in cell A3.
• Select Data, Form and click the Close button on the form.
• Click the Stop Recording button on the Stop Recording toolbar (the button on the left).
• Now try your macro out by pressing Ctrl-m.
The data form should be displayed ready for you to edit the list.
Note: If you get ### displayed on your data form for the Normal Gross Monthly Salary you will need to
widen cell G2 so that the text is not wrapped. You may get a $ sign here too – another quirk of
Excel!
18.5. Adding command buttons
If you are going to have several macros in a system it can be difficult to remember which key sequence
activates which macro. Adding a labelled command button makes the system easier for people to use.
We will develop the Home worksheet to incorporate buttons for different activities.
• Open the Home worksheet.
• Select the entire worksheet by clicking in the top left-hand corner (to the left of the column A
header) and shade it in light grey.
• In cell A1 enter the company name ShoeShock in Comic Sans MS, 48pt, bold, red. In cell A2 enter
the heading Finance Department and in A3 Overtime Collection, both in Comic Sans MS, 14pt,
bold, black.
• Centre these headings across the screen.
• From the View menu, select Toolbars, Forms.
The Forms toolbar will be displayed.
Command button
Figure 18.7: The Forms toolbar
• Click the Command button icon.
• Mark out the position for the button on the Home worksheet.
• Assign the macro EditStaffList. (If you have clicked away from the button, right-click it and
select Assign Macro.)
• Click OK.
• Edit the button name by right-clicking the button and selecting Edit Text. At the cursor type in
Edit Staff.
154