[Year 12 IT Apps] Macros in Excel

[Daniel Stanley]

How about sorting columns, or deleting a row of data to prepare for new
data entries (a student came up with that one...)
What about a macro that opens a the Onscreen User Help?

Regards,
 
Daniel Stanley
IT Co-ordinator for
Carrum Downs Campus
Flinders Christian Community College
e: daniel.stanley at flinders.vic.edu.au
w: 03 97850000 
f:   03 97735710 
 

"All we have to decide is what to do with the time that is given to us."

J.R.R Tolkien, The Fellowship of the Ring
British scholar & fantasy novelist (1892 - 1973) 


-----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