+ Post New Thread
Results 1 to 5 of 5
Windows Thread, Macro Security in Technical; For A-Level IT the little darlings need to use a lot of macros and stuff and it is a little ...
  1. #1

    Ric_'s Avatar
    Join Date
    Jun 2005
    Location
    London
    Posts
    7,590
    Thank Post
    109
    Thanked 762 Times in 593 Posts
    Rep Power
    180

    Macro Security

    For A-Level IT the little darlings need to use a lot of macros and stuff and it is a little annoying for them having to change the security level every time they load a file.

    What is the best way to allow macros? - digitally sign/lower security level/?

    Please help

  2. #2

    Geoff's Avatar
    Join Date
    Jun 2005
    Location
    Fylde, Lancs, UK.
    Posts
    11,803
    Thank Post
    110
    Thanked 583 Times in 504 Posts
    Blog Entries
    1
    Rep Power
    224

    Re: Macro Security

    Generate a certificate for them to use to sign their code with.

  3. #3

    Join Date
    Aug 2005
    Location
    Birmingham, UK
    Posts
    490
    Thank Post
    0
    Thanked 0 Times in 0 Posts
    Rep Power
    0

    Re: Macro Security

    Well considering they can change the macro level to bypass the high security settings anyway, why not set it to medium so it at least prompts them?

    The only time i wouldnt do this is if i controlled macro policies and didnt let them change the settings, but seeng as the ycan change the settings it mayaswell be on medium.

  4. #4

    Ric_'s Avatar
    Join Date
    Jun 2005
    Location
    London
    Posts
    7,590
    Thank Post
    109
    Thanked 762 Times in 593 Posts
    Rep Power
    180

    Re: Macro Security

    It is currently on Medium setting and they are able to change it - it's just annoying for the teaching staff to have to go through the prompt several times during a demonstration if they have several files to open.

    @Geoff: Do you recommend that I create a single certificate for all or set up a certificate server allowing them to produce their own certificates? Ideas of how best to implement are more than welcome.

  5. #5

    Geoff's Avatar
    Join Date
    Jun 2005
    Location
    Fylde, Lancs, UK.
    Posts
    11,803
    Thank Post
    110
    Thanked 583 Times in 504 Posts
    Blog Entries
    1
    Rep Power
    224

    Re: Macro Security

    Setup a single certificate for each group of people (class/year/whatever). Create new certificates every year/term (make sure the old ones expire!). Do not allow anyone other than yourself to create/manage certificates.

    I have a sneaking suspicion you'll need W2k3 Server Enterprise edition to pull this off though. I don't think Standard edition has the PKI services you need.

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. Macro and VBA functions
    By randle in forum Windows
    Replies: 10
    Last Post: 9th February 2007, 09:32 AM
  4. Excel Macro - Edexcel GCE Exams
    By steve in forum Educational Software
    Replies: 0
    Last Post: 16th May 2006, 02:49 PM
  5. Replies: 2
    Last Post: 12th January 2006, 09:32 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
  •