[Year 12 IT Apps] Macros in Excel

[David Howard]

I have already sent this today but I used a macro to copy the sheet,
rename it, clear the original and reselect the original cell. Look at
the code behind the macro for the full understanding.

-----Original Message-----
From: itapps-bounces at edulists.com.au
[mailto:itapps-bounces at edulists.com.au] On Behalf Of Russell Edwards
Sent: Wednesday, 25 July 2007 3:38 PM
To: Year 12 IT Applications Teachers' Mailing List
Subject: [Year 12 IT Apps] Macros in Excel

Does anyone have any thoughts on common uses of macros in Excel?

I am struggling to come up with any examples that are generally  
applicable, and therefore worth putting in to student exercises.    I  
use macros occasionally but they are generally quite specific to the  
particular job that spreadsheet is designed for.

About all I can think of would be setting the active cell to the  
first input data cell upon opening, and inter-sheet navigation buttons.

thanks in advance

Russell
Whittlesea SC


Important - This email and any attachments may be confidential. If
received in error, please contact us and delete all copies. Before
opening or using attachments check them for viruses and defects.
Regardless of any loss, damage or consequence, whether caused by the
negligence of the sender or not, resulting directly or indirectly from
the use of any attached files our liability is limited to resupplying
any affected attachments. Any representations or opinions expressed are
those of the individual sender, and not necessarily those of the
Department of Education.
_______________________________________________
http://www.edulists.com.au - FAQ, resources, subscribe, unsubscribe
IT Applications Mailing List kindly supported by
http://www.vcaa.vic.edu.auvce/studies/infotech/itapplications3-4.html -
Victorian Curriculum and Assessment Authority and
http://www.vitta.org.au  - VITTA Victorian Information Technology
Teachers Association Inc

E-MAIL DISCLAIMER 
This e-mail and any files transmitted with it contain confidential information intended for the use of the individual or entity named above. If you are not the intended recipient of this e-mail you are hereby notified that you must not disseminate, copy or take action in reliance upon it. If you have received this message in error, please notify the sender immediately by return e-mail or telephone Reception at Padua College on (03) 5976 0100.


-------------- next part --------------
A non-text attachment was scrubbed...
Name: Playhouse solution v1.0.xls
Type: application/vnd.ms-excel
Size: 66048 bytes
Desc: Playhouse solution v1.0.xls
Url : http://www.edulists.com.au/pipermail/itapps/attachments/20070725/eac7a0fe/Playhousesolutionv1.0-0001.xls