PowerPoint Macros in VBA

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 [login to view URL]’ 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 [login to view URL]’ 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: [login to view URL], [login to view URL] and [login to view URL] so must not refer to ‘Remove text [login to view URL]’ 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.