+ Post New Thread
Results 1 to 11 of 11
Windows Thread, Macro and VBA functions in Technical; What are peoples general opinions about allowing students usage of Macro and VBA functions? these are disabled by default on ...
  1. #1
    randle's Avatar
    Join Date
    Dec 2006
    Location
    Chelmsford, Essex
    Posts
    594
    Thank Post
    66
    Thanked 16 Times in 15 Posts
    Rep Power
    19

    Macro and VBA functions

    What are peoples general opinions about allowing students usage of Macro and VBA functions?

    these are disabled by default on CC3 for an RM Standard usertype but know that our ICT teachers at some point will need these enabled when teaching students how to make/use these. I know custom usertypes can be created and allocated to selected year groups to allow this but would like to know if this is highly ill-advised

  2. #2

    Join Date
    Feb 2006
    Posts
    1,187
    Thank Post
    0
    Thanked 1 Time in 1 Post
    Rep Power
    0

    Re: Macro and VBA functions

    Even if VBA is enable they should still be running with Windows restricted user rights. This means that NTFS ang reg permissions will stop them from doing any real damage.

    I'll have to check but I think they also can't undo group policies either.

    With AV and a good web filtering solution in place there won't much opportunity for doing anything l33t.

  3. #3

    webman's Avatar
    Join Date
    Nov 2005
    Location
    North East England
    Posts
    8,400
    Thank Post
    636
    Thanked 961 Times in 661 Posts
    Blog Entries
    2
    Rep Power
    319

    Re: Macro and VBA functions

    We have CC3, and for the term(s) when pupils need to run macros we ask for a class list and just bump them up to Advanced users. When they've finished we just put them back to Restricted.

  4. #4
    randle's Avatar
    Join Date
    Dec 2006
    Location
    Chelmsford, Essex
    Posts
    594
    Thank Post
    66
    Thanked 16 Times in 15 Posts
    Rep Power
    19

    Re: Macro and VBA functions

    That was the solution really but i wanted to stay away from the changing of usertype as i'd just forget to revoke these permissions knowing me.

  5. #5
    mark's Avatar
    Join Date
    Jun 2005
    Posts
    3,958
    Thank Post
    248
    Thanked 49 Times in 45 Posts
    Blog Entries
    2
    Rep Power
    46

    Re: Macro and VBA functions

    We had a problem today with a kid that had made up a word document with a web browser built in. How _do_ you disable macro's anyway?

  6. #6

    Gatt's Avatar
    Join Date
    Jan 2006
    Posts
    6,644
    Thank Post
    858
    Thanked 645 Times in 428 Posts
    Rep Power
    498

    Re: Macro and VBA functions

    My Office 2k3 build has macros's disabled which I am glad about cos i don't trust them here not to abuse them

    Recently had to disabled pen drives for Year 09's due to them embedding Flash games inside Excel Spreadsheetss and copying them to their home drives (since .xls is allowed, but .swf files aren't - tho if SLT get their way I'll have to open up SWF so the kiddies can to FLASH )

  7. #7

    Join Date
    Feb 2006
    Location
    London
    Posts
    126
    Thank Post
    1
    Thanked 17 Times in 9 Posts
    Rep Power
    20

    Re: Macro and VBA functions

    Quote Originally Posted by randle
    That was the solution really but i wanted to stay away from the changing of usertype as i'd just forget to revoke these permissions knowing me.
    Rather than bump the user type up to advanced, I copied the standard type and just added alow macros to that. Still a change of user type but only adds the minimal extra rights, so not quite as important if I forget ( or more likely don't get told they no longer need them ) to change back.

  8. #8
    randle's Avatar
    Join Date
    Dec 2006
    Location
    Chelmsford, Essex
    Posts
    594
    Thank Post
    66
    Thanked 16 Times in 15 Posts
    Rep Power
    19

    Re: Macro and VBA functions

    Rather than bump the user type up to advanced, I copied the standard type and just added alow macros to that. Still a change of user type but only adds the minimal extra rights, so not quite as important if I forget ( or more likely don't get told they no longer need them ) to change back.
    This is what i've done but still don't like the idea of allowing this seeing as the extra rights can be quite harmful in the hands of a clever student who can easily show other students once he realises the opportunity is there.

    How _do_ you disable macro's anyway?
    You can do this via a GPO. RM have a custom one for this but if you know how to write adm template files, you can create this yourself

  9. #9
    mark's Avatar
    Join Date
    Jun 2005
    Posts
    3,958
    Thank Post
    248
    Thanked 49 Times in 45 Posts
    Blog Entries
    2
    Rep Power
    46

    Re: Macro and VBA functions

    Quote Originally Posted by randle

    How _do_ you disable macro's anyway?
    You can do this via a GPO. RM have a custom one for this but if you know how to write adm template files, you can create this yourself
    Nope

  10. #10

    Join Date
    Mar 2006
    Posts
    537
    Thank Post
    2
    Thanked 3 Times in 2 Posts
    Rep Power
    18

    Re: Macro and VBA functions

    Quote Originally Posted by Gatt
    Recently had to disabled pen drives for Year 09's due to them embedding Flash games inside Excel Spreadsheetss and copying them to their home drives (since .xls is allowed, but .swf files aren't - tho if SLT get their way I'll have to open up SWF so the kiddies can to FLASH )
    Actually, all Office files with embedded flash games have the word shockwaveflash written in clear text somewhere. I imagine it wouldn't take much to create a grep and squish script.. Add a bit of logging for evidence and run after the nightly backup.

    Things will hopefully get easier once the world decides on an XML format for office documents.

    Does anybody if it is possible to create custom AV signatures for this kind of thing. As Clam is opensource does this run to their sigs?

  11. #11
    randle's Avatar
    Join Date
    Dec 2006
    Location
    Chelmsford, Essex
    Posts
    594
    Thank Post
    66
    Thanked 16 Times in 15 Posts
    Rep Power
    19

    Re: Macro and VBA functions

    Quote Originally Posted by mark
    Quote Originally Posted by randle

    How _do_ you disable macro's anyway?
    You can do this via a GPO. RM have a custom one for this but if you know how to write adm template files, you can create this yourself
    Nope
    I think Microsoft may have some adm templates on their site to help with this or just try a google

SHARE:
+ Post New Thread

Similar Threads

  1. Prommisor - Installing using a batch file/macro?
    By googlemad in forum Windows
    Replies: 21
    Last Post: 3rd December 2007, 08:17 PM
  2. help with excel macro needed
    By oyoung in forum Windows
    Replies: 0
    Last Post: 30th March 2007, 10:27 AM
  3. Excel Macro - Edexcel GCE Exams
    By steve in forum Educational Software
    Replies: 0
    Last Post: 16th May 2006, 02:49 PM
  4. Replies: 2
    Last Post: 12th January 2006, 09:32 AM
  5. Macro Security
    By Ric_ in forum Windows
    Replies: 4
    Last Post: 4th October 2005, 08:59 AM

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •