PowerPoint Macros in VBA

IN PROGRESS
Bids
6
Avg Bid (USD)
$88
Project Budget (USD)
$30 - $250

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 17.22 from top left corner

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

No Fill No Line

Box 16.80 cm long to match one in ‘Remove text box.pot’ 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

Scenario
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 box.pot’ 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: MNZ.pot, RCCNZ.pot and MPRS.pot so must not refer to ‘Remove text box.pot’ 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.

Skills required:
Visual Basic
Additional Files: Remove text box.zip
Hire kenchand
Project posted by:
kenchand
Verified
Public Clarification Board
Bids are hidden by the project creator. Log in as the employer to view bids or to bid on this project.
You will not be able to bid on this project if you are not qualified in one of the job categories. To see your qualifications click here.


$ 80
in 4 days
Hire nmppatel
$ 60
in 0 days
Hire crajeshbe
$ 150
in 2 days
Hire johnsinit
$ 88
in 2 days
Hire ioanaprof
$ 99
in 4 days
Hire arlee04
$ 50
in 0 days