[Year 12 IT Apps] Macros in Excel

Bane, Janet A bane.janet.a at edumail.vic.gov.au
Wed Jul 25 16:40:56 EST 2007


Hi Russell
 
I am trying to get my head around Macros as well. I found some examples in a book called PC Simplicity and adapted them for my class.  Feel free to use, modify or disregard.
 
regards,
 
Janet Bane
Patterson River SC

________________________________

From: itapps-bounces at edulists.com.au on behalf of Russell Edwards
Sent: Wed 25-Jul-07 3:37 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 <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 <http://www.vitta.org.au/>   - VITTA Victorian Information Technology Teachers Association Inc



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.
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/ms-tnef
Size: 68125 bytes
Desc: not available
Url : http://www.edulists.com.au/pipermail/itapps/attachments/20070725/147e8cc7/attachment-0001.bin


More information about the itapps mailing list