[Year 12 IT Apps] U4 O1 - Excel 2007 & macros

[Anderson, Stuart L]

Granted, it's far more convoluted in certain aspects to do macros than it used to be, but they can still do them.
 
The main hitch is that it doesn't automatically appear on the toolbar. Click on the Office button (to the left of the antiquated save icon) then "Excel Options"  Under "Popular" select "Show Developer Tab in the Ribbon"
 
Of course you'll still have the issue of macros being automatically disabled each time they get in (which can be easily overcome) but that's where you can mention the reasons why there are restrictions in a networked environment.
 
Good luck!
 
- Stuart Anderson
 
 
________________________________

From: itapps-bounces at edulists.com.au on behalf of Jock Garnsworthy
Sent: Thu 14/08/2008 9:21 AM
To: Year 12 IT Applications Teachers' Mailing List
Subject: [Year 12 IT Apps] U4 O1 - Excel 2007 & macros


Hi all,
One of the powerful SS features that I teach my students for U4 O1 (and other year levels) is the use of macros to automate procedures within a spreadsheet.
As Office 2007 creeps into our environment, it seems this powerful feature is no longer accessible due to the decision of the Microsoft programmers.
Does anyone else share my frustration in this quite strange loss and has anyone found a work around.
I am loathe to suggest to the techies we keep Excel 2003 on the system as I can predict their response.

Remaining confused ,

Jock Garnsworthy
Williamstown High School
ga at willihigh.vic.edu.au





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 Williamstown High School._______________________________________________ 
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.au/vce/studies/infotech/infotechindex.html <http://www.vcaa.vic.edu.au/vce/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 and Early Childhood Development.
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/ms-tnef
Size: 5598 bytes
Desc: not available
Url : http://www.edulists.com.au/pipermail/itapps/attachments/20080814/eed8ed17/attachment.bin