[Year 12 IT Apps] Macros in Excel

[Sam Denniston]

All I used them for was to create a quick bar chart displaying web design
and software sales for each employee on a particular week. (VCE Study Design
sample SAC)


On 25/7/07 4:40 PM, "Bane, Janet A" <bane.janet.a at edumail.vic.gov.au> wrote:

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