PowerPoint Macros in VBA

This project was awarded to johnsinit for $88 USD.

Get free quotes for a project like this
Employer working
Awarded to:
Skills Required
Project Budget
Total Bids
Project Description

Specifications for PowerPoint Template modifications. Please provide a quotation and expected delivery date.

On creating a new presentation in PPT 2003 on using the Template:

An Input form to display asking:

Do you want to add the presenter’s name and date of presentation to the Title slide?

If user click’s no: remove bottom text box from Title slide which contains the words “Add name here Day Month year”.

If user click’s yes:
Display another input form with the following fields:

Date of presentation: ____________________

Presenter’s name: ____________________

Please control the date format to display as 3 June 2009 but not 03 June 2009 (ie month and year in full – single digit for 3). The user should be able to type 3 space 6 and when they tab to the next field date converts to the above format.

They should also be able to type: 3 Jun or 3 June or 3/6 and it should convert to the above format and default to the current year.

When the user click’s OK, the text box to be filled in with the results of the date and presenter’s name fields.

It is important that the code will run from anywhere in the presentation and it will insert the Presenter’s text box on the Title Slide only.

Accelerator keys for input fields.

Cancel button on input form.

The text box measurments are to be:

Position – horizontal 2.2 from Top left corner
Position – Vertical [url removed, login to view] from top left corner

Text box internal margin:
Left .25 Right .25 Top .13 bottom .13

No Fill No Line

Box [url removed, login to view] cm long to match one in ‘Remove text [url removed, login to view]’ template.

Font in text box:

‘Add name here plus 3 spaces using spacebar after this text’ = White Arial 25 point bold.
‘Day Month Year’ = Colour R150 G150 B150 Arial 25 point (regular)

New macro

The user has now been working on the presentation for some time. They change their mind regarding having the Presenter’s name text box on the Title Slide and need to remove it. Or have removed it and now want to insert it again.

Is it possible to create code that will check the Title Slide and if the Presenter’s text box is present, delete it.

If the text box is not present, insert Presenter’s text box as per code above, displaying the input form for the fields etc.

The button to run this macro to be named: Show/Hide text box on Title Slide. Position the button on the Formatting toolbar to the right of the location of the default ‘New Slide’ button.

We recorded macros and stored in the ‘Remove text [url removed, login to view]’ file – this is what they are doing – they are to help you understand what we are wanting to achieve.
Macro3 – inserts text box on Title Slide.

This is a recorded macro – can you code as per above? Ie when the button
It is important that the code will run from anywhere in the presentation and it will insert the Presenter’s text box on the Title Slide only.

Macro 1 – Remove text box

This pre-recorded macro doesn’t work because the text box number is modified each time a new text box is added via Macro3.

Please create code that will consistently delete the Presenter’s text box (that has been inserted by Macro3 above) at the bottom of the Title Slide only.

New Macro

Create an autonew and autopen macro (or whatever is required) that will remove the New Slide button and Bullets button found on the Formatting toolbar in PowerPoint on creating a new presentation based on attached template or opening a presentation based on the attached template.

Create an autoclose macro (or whatever is required) that will on closing presentation based on the above template, reinstate the above buttons (ie reset the Formatting toolbar). This code will be added to three templates named: [url removed, login to view], [url removed, login to view] and [url removed, login to view] so must not refer to ‘Remove text [url removed, login to view]’ in the code.

Please confirm how we distribute this code to end-user, ie. PPA or embedded in templates?

This peoject is urgent and must be completed within 7 days.

Looking to make some money?

  • Set your budget and the timeframe
  • Outline your proposal
  • Get paid for your work

Hire Freelancers who also bid on this project

    • Forbes
    • The New York Times
    • Time
    • Wall Street Journal
    • Times Online