+ Post New Thread
Page 1 of 2 12 LastLast
Results 1 to 15 of 16
Office Software Thread, Enabling macros across the network in Technical; I have have excel spreadsheets on my server ( ICT subject resources) and they all come up with high security ...
  1. #1
    silver's Avatar
    Join Date
    Dec 2008
    Location
    South
    Posts
    153
    Thank Post
    9
    Thanked 13 Times in 6 Posts
    Rep Power
    13

    Enabling macros across the network

    I have have excel spreadsheets on my server (ICT subject resources) and they all come up with high security so macros are disabled.

    I can change it back as admin, but it doesnt stay so presumably there is a setting somewhere else which resets the security level to high when you log off and on again

    Can anyone help - there are a lot of spreadsheets!

  2. #2

    Little-Miss's Avatar
    Join Date
    Oct 2007
    Location
    Birmingham
    Posts
    5,348
    Thank Post
    2,330
    Thanked 622 Times in 418 Posts
    Blog Entries
    2
    Rep Power
    508
    Enabling Macro's

    Follows Michaels advice

  3. #3
    silver's Avatar
    Join Date
    Dec 2008
    Location
    South
    Posts
    153
    Thank Post
    9
    Thanked 13 Times in 6 Posts
    Rep Power
    13
    Thanks for that - unfortunately I dont understand where it says 'install template whatever'
    I have downloaded and run the office 2003 resource kit - now what do I do?
    Sorry to be so thick

  4. #4


    Join Date
    Feb 2007
    Location
    Northamptonshire
    Posts
    4,657
    Thank Post
    350
    Thanked 789 Times in 710 Posts
    Rep Power
    344
    Are you on a vanilla network or ?

  5. #5

    Michael's Avatar
    Join Date
    Dec 2005
    Location
    Birmingham
    Posts
    8,941
    Thank Post
    232
    Thanked 1,510 Times in 1,206 Posts
    Rep Power
    328
    Working on the presumption you are using a vanilla network, you need to install ORK tools on your main server, usually the Curriculum server where Active Directory is running.

    This will then install/copy the Office ADM template files to the C:\Windows\INF or C:\WinNT\INF directory where existing ADM template files are stored.

    Open up Active Directory and navigate to the OU where your pupils account objects are located. Now this next step will look different depending if you have GPMC installed (which as a recommendation you should). If it doesn't look as I am describing things, skip the next paragraph.

    Right click the Curriculum or equivalent OU, choose 'Properties', then choose the 'Group Policy' tab and click on 'Open'. You should then see a GPO listed. Right click it and choose 'Edit'.

    Under the sub heading 'User Configuration', right click 'Administrative Templates' and choose 'Add/Remove Templates'. Add the relevant template, then click 'Close'. You can now tweak the policy or policies you require.

  6. #6
    silver's Avatar
    Join Date
    Dec 2008
    Location
    South
    Posts
    153
    Thank Post
    9
    Thanked 13 Times in 6 Posts
    Rep Power
    13
    right - not going completely mad - I did manage the install as above and
    I have done the template office11 install but when I look at the files I cannot find one called tools/macros or similar
    I seem to have looked everywhere
    What am I not doing now? *sigh*

  7. #7

    Michael's Avatar
    Join Date
    Dec 2005
    Location
    Birmingham
    Posts
    8,941
    Thank Post
    232
    Thanked 1,510 Times in 1,206 Posts
    Rep Power
    328
    The template you need to add is Word11.

  8. #8

    elsiegee40's Avatar
    Join Date
    Jan 2007
    Location
    Kent
    Posts
    10,049
    Thank Post
    1,680
    Thanked 2,021 Times in 1,495 Posts
    Rep Power
    673
    The alternative is Mandatory Profiles.

    Change ntuser.man to ntuser.dat

    use a logon on that profile and enable macros

    Logoff and let the profile save back to the server

    rename ntuser.dat to ntuser,man

    Bob's your aunty!

  9. #9

    Michael's Avatar
    Join Date
    Dec 2005
    Location
    Birmingham
    Posts
    8,941
    Thank Post
    232
    Thanked 1,510 Times in 1,206 Posts
    Rep Power
    328
    Bob's your aunty!


    Yes you can do it this way, but GPO is better. Plus you have other various Office policies you can set. If you haven't used ORK tools before I'd recommend it

  10. #10

    Little-Miss's Avatar
    Join Date
    Oct 2007
    Location
    Birmingham
    Posts
    5,348
    Thank Post
    2,330
    Thanked 622 Times in 418 Posts
    Blog Entries
    2
    Rep Power
    508
    I did it Michael's way and it was really simple to do....just cant remember how i did it!! lol

  11. #11
    silver's Avatar
    Join Date
    Dec 2008
    Location
    South
    Posts
    153
    Thank Post
    9
    Thanked 13 Times in 6 Posts
    Rep Power
    13
    I found the correct template - (but I chose Excel11 not Word11, is that not right?) and set the level to medium
    The machines are still giving me the error message about the security level set too high
    Last edited by silver; 3rd April 2009 at 11:10 AM.

  12. #12

    Michael's Avatar
    Join Date
    Dec 2005
    Location
    Birmingham
    Posts
    8,941
    Thank Post
    232
    Thanked 1,510 Times in 1,206 Posts
    Rep Power
    328
    I'm sorry but I have definitely installed the ork tools and there doesnt seem to be a template for word11, only office11
    If you logon to your server, open up My Computer > Local Disk (C: ) (it might be labelled something else), then double click either Windows or WinNT. Now double click the INF folder. There will be loads of files in here, but don't worry.

    Click on Search > All files and folders, then in the top field enter *.adm and click Search. All the template files will/should be displayed. Does Word11 appear here?

  13. #13
    silver's Avatar
    Join Date
    Dec 2008
    Location
    South
    Posts
    153
    Thank Post
    9
    Thanked 13 Times in 6 Posts
    Rep Power
    13
    I have found the Word11 template and set macros in that as well. Made sure the GP is applied to the right computers, done gpupdate /force /boot and the machines are still showing high level of security in all excel spreadsheets
    What else can I do?

  14. #14
    silver's Avatar
    Join Date
    Dec 2008
    Location
    South
    Posts
    153
    Thank Post
    9
    Thanked 13 Times in 6 Posts
    Rep Power
    13
    I seem to have sorted it. I had applied the gp to computers and not users
    I don't understand why it didn't work when applied to computers - can someone tell me?

  15. #15
    chrbb's Avatar
    Join Date
    Oct 2005
    Location
    Midlands
    Posts
    1,506
    Thank Post
    141
    Thanked 66 Times in 61 Posts
    Rep Power
    46
    Because the excel/office settings are set per user, each settings stored in users profiles. (I think)

SHARE:
+ Post New Thread
Page 1 of 2 12 LastLast

Similar Threads

  1. [MS Office - 2003] Enabling Macro's
    By Little-Miss in forum Office Software
    Replies: 17
    Last Post: 23rd March 2009, 03:37 PM
  2. [MS Office - 2003] Access - Conditional Macros
    By garethedmondson in forum Office Software
    Replies: 5
    Last Post: 27th January 2009, 12:06 AM
  3. Replies: 6
    Last Post: 24th February 2008, 07:37 PM
  4. Mandatory Profiles and Macros
    By Midget in forum Windows
    Replies: 3
    Last Post: 24th January 2007, 05:07 PM
  5. Replies: 4
    Last Post: 29th June 2005, 12:43 PM

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
  •