PowerPoint Project 5

1
PowerPoint Project 5

• Working with Macros and Visual Basic for
  Applications (VBA)

2
Objectives

• Create a toolbar
• Customize a toolbar by adding buttons
• Use the macro recorder to create a macro
• Customize a menu by adding a command
• Open a presentation and print it by executing a
  macro

3
Objectives

• Create a form to customize a presentation
• Create a user interface
• Add controls, such as command buttons and combo
  boxes, to a form
• Assign properties to controls
• Write VBA code to create a unique presentation

4
Creating a Custom Toolbar

• Open the Travel presentation from your Data Disk
  in Microsoft Office PowerPoint 2003, according to
  the instructions on pages PPT 349 PPT 350
• Click Tools on the menu bar and then point to
  Customize
• Click Customize
• If necessary, when the Customize dialog box
  appears, click the Toolbars tab
• Click the New button

5
Creating a Custom Toolbar

• When the New Toolbar dialog box appears, type
  Vacation in the Toolbar name text box
• Click the OK button
• Click the Close button in the Customize dialog
  box
• Click the Vacation toolbar and drag it to the
  bottom-right corner of the screen beside the
  Drawing toolbar

6
Creating a Custom Toolbar
7
Adding Two Buttons to the Vacation Toolbar

• Click the Toolbar Options button on the new
  toolbar
• Point to Add or Remove Buttons, and then point to
  Customize on the Add or Remove Buttons submenu
• Click Customize
• When the Customize dialog box is displayed, click
  the Commands tab
• Scroll down in the Commands list and then click
  Save as Web Page

8
Adding Two Buttons to the Vacation Toolbar

• Drag the Save as Web Page command from the
  Commands list to the new Vacation toolbar
• Scroll down in the Commands list and then click
  Package for CD
• Drag the Package for CD command from the Commands
  list to the right of the Save as Web Page button
  on the Vacation toolbar
• Click the Modify Selection button and then point
  to Change Button Image
• When the Change Button Image palette is
  displayed, point to the button with three circles
  (row 6, column 4)

9
Adding Two Buttons to the Vacation Toolbar

• Click the button with the three circles image
• Click the Modify Selection button and then point
  to Default Style
• Click Default Style
• Click the Close button in the Customize dialog box

10
Adding Two Buttons to the Vacation Toolbar
11
Recording a Macro

• Click Tools on the menu bar, point to Macro, and
  then point to Record New Macro on the Macro
  submenu
• Click Record New Macro
• When the Record Macro dialog box is displayed,
  type PrintHandout in the Macro name text box
• Type Macro prints Pure Black and White handouts
  in vertical slide order in the Description text
  box
• Make sure the Store macro in box displays
  Vacation Central

12
Recording a Macro

• Click the OK button
• Click File on the menu bar and then click Print
• When the Print dialog box is displayed, click the
  Print what box arrow and then click Handouts
• Click the Slides per page box arrow in the
  Handouts area and then click 4
• Click Vertical order in the Handouts area

13
Recording a Macro

• Click the Color/grayscale box arrow and then
  click Pure Black and White
• Click the OK button
• Click File on the menu bar and then click Print
• When the Print dialog box is displayed, click the
  Color/grayscale box arrow and then click
  Grayscale (or your computers default print
  option)
• Click the Slides per page box arrow in the
  Handouts area and then click 6

14
Recording a Macro

• Click Horizontal order in the Handouts area
• Click the Print what box arrow and then click
  Slides
• Click the OK button
• Point to the Stop Recording button
• Click the Stop Recording button

15
Recording a Macro
16
Adding a Command to a Menu, Assigning the Command
to a Macro, and Invoking the Command

• Click Tools on the menu bar and then click
  Customize
• If necessary, when the Customize dialog box is
  displayed, click the Commands tab
• Scroll down in the Categories list and then click
  Macros
• Click File on the menu bar to display the File
  menu
• Drag the PrintHandout entry from the Commands
  list in the Customize dialog box immediately
  below the Print command on the File menu

17
Adding a Command to a Menu, Assigning the Command
to a Macro, and Invoking the Command

• Right-click PrintHandout on the File menu and
  then click the Name label on the shortcut menu
• Type Print BW Handout as the new name of this
  command
• Click the Close button at the bottom of the
  Customize dialog box
• Click File on the menu bar and then point to
  Print BW Handout
• Click Print BW Handout on the File menu

18
Adding a Command to a Menu, Assigning the Command
to a Macro, and Invoking the Command
19
Opening a Presentation with a Macro and Executing
the Macro

• With PowerPoint active, click File on the menu
  bar and then click Open
• If necessary, when the Open dialog box is
  displayed, click the Look in box arrow, and
  navigate to the folder where your files are
  stored
• Double-click the file name, Vacation Central
• If the Security Warning dialog box is displayed,
  click the Enable Macros button
• When Slide 1 of the Vacation Central presentation
  is displayed, click File on the menu bar and then
  click Print BW Handout

20
Opening a Presentation with a Macro and Executing
the Macro
21
Opening the Visual Basic IDE and a New Form

• With the Vacation Central presentation still
  open, click Tools on the menu bar, point to
  Macro, and then point to Visual Basic Editor
• Click Visual Basic Editor
• If the VBA code displays, click the Close button
  in the upper-right corner of the Vacation Central
  - Module 1 (Code) window. You may need to drag
  the window to the left to view this Close button

22
Opening the Visual Basic IDE and a New Form

• Click Insert on the menu bar and then point to
  UserForm
• Click UserForm
• If the Toolbox does not display, click the
  Toolbox button on the Standard toolbar

23
Opening the Visual Basic IDE and a New Form
24
Changing the Form Size and the Toolbox Location

• Without releasing the mouse button, drag the form
  windows bottom border down
• Release the mouse button
• Without releasing the mouse button, drag the
  forms bottom-center sizing handle down
• Release the mouse button
• Click the Toolbox title bar and drag it to the
  lower-right side of the form window

25
Changing the Form Size and the Toolbox Location
26
Adding Label and Combo Box Controls to a Form

• Click the Label button in the Toolbox
• Position the mouse pointer in the upper-left
  corner of the form
• Click the mouse button
• Click the ComboBox button in the Toolbox

27
Adding Label and Combo Box Controls to a Form

• Position the mouse pointer below the Label1
  control
• Click the mouse button
• Repeat the previous steps to add the second and
  third Label controls and second and third
  ComboBox controls to the form as shown on the
  following slide

28
Adding Label and Combo Box Controls to a Form
29
Adding Command Button Controls to a Form

• Click the CommandButton button in the Toolbox
• Position the mouse pointer in the lower-left
  corner of the form
• Click the mouse button
• Repeat the previous steps to add a second
  CommandButton control, CommandButton2, as shown
  on the following slide

30
Adding Command Button Controls to a Form
31
Setting the Controls Caption Properties

• Click the Label1 control
• With the Label1 control selected, click Caption
  on the Alphabetic tab in the Properties window
• Double-click the current caption, Label1, to
  select it, type Add a background as the caption,
  and then press the ENTER key
• Change the captions for the remainder of the
  controls on the form using the information from
  Table 5-5 on page PPT 385

32
Setting the Controls Caption Properties
33
Resizing and Repositioning Controls on a Form

• Click the Label1 control, Add a background
• Change its Top, Left, Height, and Width
  properties in the Properties window to those
  listed in Table 5-6 on page PPT 386
• One at a time, select the controls and change
  their Top, Left, Height, and Width properties to
  those listed in Table 5-6

34
Resizing and Repositioning Controls on a Form
35
Entering the Create Presentation Procedure

• Click the Insert UserForm button arrow on the
  Standard toolbar and then point to Module
• Click Module in the Insert UserForm list
• When the Visual Basic Editor opens, click the
  Maximize button in the Vacation Central -
  Module2 (Code) window
• Type the seven comment statements (lines 1
  through 7) shown in Table 5-7 on page PPT 388. Be
  certain to enter an apostrophe at the beginning
  of each comment line

36
Entering the Create Presentation Procedure

• Press the ENTER key to position the insertion
  point on the next line
• Enter lines 8 through 10 shown in Table 5-7 on
  page PPT 388. Do not enter the End Sub statement
  (line 11). For clarity, indent all lines between
  the Sub statement and End Sub statement by three
  spaces
• Click the Close Window button on the right side
  of the menu bar

37
Entering the Create Presentation Procedure
38
Entering the InitializeForm() Procedure

• With UserForm1 selected in the Project window,
  point to the View Code button at the top of the
  Project Explorer window
• If UserForm1 is not selected, click the form
• Click the View Code button
• Enter the VBA code shown in Table 5-10 on page
  PPT 392

39
Entering the InitializeForm() Procedure
40
Entering the CommandButton1 Procedure

• Click the Object box arrow at the top of the Code
  window, and then point to CommandButton1 in the
  Object list
• Click CommandButton1
• Make sure Click is in the Procedure box
• Enter the VBA code shown in lines 1 through 12 in
  Table 5-12 on page PPT 394. Do not press the
  ENTER key after typing the End With statement in
  line 12

41
Entering the CommandButton1 Procedure
42
Entering the CommandButton2 Procedure

• Click the Object box arrow in the Code window,
  and then click CommandButton2 in the Object box
• Make sure Click is in the Procedure box
• Enter the VBA code shown in Table 5-15 on page
  PPT 397

43
Entering the CommandButton2 Procedure
44
Initializing a Path Constant

• Click the Object box arrow and then click
  (General)
• Type Const Path "c\", replacing c with the
  actual location of the video and photo files on
  your system. Make sure a \ is at the end of your
  path
• Press the ENTER key
• Type Dim Templname As String and then press the
  ENTER key

45
Initializing a Path Constant
46
Summary

• Create a toolbar
• Customize a toolbar by adding buttons
• Use the macro recorder to create a macro
• Customize a menu by adding a command
• Open a presentation and print it by executing a
  macro

47
Summary

• Create a form to customize a presentation
• Create a user interface
• Add controls, such as command buttons and combo
  boxes, to a form
• Assign properties to controls
• Write VBA code to create a unique presentation

48
PowerPoint Project 5 Complete