Wiley 978-0-470-59159-8 Datový list

212423Introducing Excel ProgrammingAs you probably know, Microsoft Excel is an electronic worksheet you can use for a variety of purposes, including t

11Chapter 1: Using Macros and Form Controls6745If you have Macro Security enabled, Excel displays the Trust Bar below the Ribbon when you open a workb

121234 The Macro dialog box appears.4 If your macro does not appear in the Macro dialog box, click the down arrow and then select the workbook that

13Chapter 1: Using Macros and Form Controls65Excel differentiates between macros listed in the Macro dialog box by placing the name of the workbook th

14624537 The Macro Options dialog box appears.4 Type the desired shortcut key. Press Shift as you type to assign an uppercase key.5 Type a descrip

15Chapter 1: Using Macros and Form Controls1If you do not use a macro shortcut frequently, it is easy to forget the keyboard shortcut you assigned to

166112453 The Excel Options dialog box appears.2 Click the down arrow and then select Macros.3 Click the down arrow and then select the workbook in

17Chapter 1: Using Macros and Form Controls8709You can also assign a macro to a custom Ribbon tab. Right-click the Microsoft Office Ribbon. A menu app

184132 The Unhide dialog box appears.3 Click the workbook you want to unhide.4 Click OK. Excel unhides the workbook. You are now in the workbook

19Chapter 1: Using Macros and Form Controls423There are two ways to create a macro. One way is to use the macro recorder to record the steps needed to

20235414 Click and drag the mouse pointer to create the control.5 Click and drag the handles on the sides and corners to adjust the size.1 Click th

356You can also use Microsoft Visual Studio Tools for the Microsoft Office System (Visual Studio) to develop programs for Microsoft Office products. W

21Chapter 1: Using Macros and Form Controls67You can add the controls listed in the following table to your worksheets.CONTROL CONTROL NAME DESCRIPTIO

222345167 The Format Object dialog box appears.3 Click the Control tab. The available fields depend on the control type. This example uses a combo

23Chapter 1: Using Macros and Form Controls88When working with a value selected from a list box or combo box control, you may want to use the value in

241423 The Record Macro dialog box appears.4 Click OK.5 Record your macro.Note: See section “Record a Macro” to learn how to record a macro.1 Righ

25Chapter 1: Using Macros and Form Controls6To assign a macro to a button, create the macro, and then click the Developer tab. Click Insert in the Con

4123 The Excel Options dialog box appears.3 Click Customize Ribbon.1 Click the File tab. A menu appears.2 Click Options.Introducing MacrosYou can

5Chapter 1: Using Macros and Form Controls546Because of problems with macro viruses, by default Excel disables all macros when you open a workbook. Yo

63412 The Trust Center dialog box appears.3 Click a macro security setting ( changes to ).4 Click OK. Excel changes your macro security setting.1

7Chapter 1: Using Macros and Form Controls1625437 The Create Digital Certificate dialog box appears.6 Type the name you want to give your certificat

87123456 The Record Macro dialog box appears.3 Type the name you want to give your macro.4 Type the shortcut key you want to assign to your macro.

9Chapter 1: Using Macros and Form Controls890A macro you create in Excel can have a relative, an absolute, or a mixed reference. If you use a relative

102331 The Visual Basic Editor appears.3 Click Tools ➔ Digital Signature.1 Click the Developer tab.Note: See the section “Introducing Macros” to le