IS225 Lab Week06

IS225 Lab Week06 - 7 Record a new macro named “Clear” a...

Info iconThis preview shows page 1. Sign up to view the full content.

View Full Document Right Arrow Icon
IS 225 Lab exercise Week 6 April 5, 2006 Recording macros Case 1 – Practice recording a simple macro 1. Create a worksheet with labels Name, Height, Weight, Interest in column A and data in column B (i.e. A1 = Name; B1 = Amila, etc.) 2. Record a new macro named “Borders”. a. Select cells A1:B4 b. Apply Fill color of your choice c. Apply text color of your choice d. Apply Font and Size of your choice e. Stop Macro recording 3. Insert a Form button (View Toolbars Forms) 4. Assign “Borders” macro to the button 5. Change the caption on the button to “Apply Formatting” 6. Click the button to test macro running
Background image of page 1
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: 7. Record a new macro named “Clear” a. Clear all Formats (Edit Clear Formats) b. Stop Macro recording 8. Insert a Form button (View Toolbars Forms) 9. Assign “Clear” macro to the button 10. Change the caption on the button to “Clear Formatting” 11. Click the button to test macro running **Note: If needed, change the Security Level to Medium to allow Macros to execute (Tools Macro Security) Complete Case Problem 3 – Trayle Bikes Complete Case Problem 4 – Yonkers Playhouse...
View Full Document

This document was uploaded on 10/17/2010.

Ask a homework question - tutors are online