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 ...
2nd April 2009, 12:46 PM #1
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!
IDG Tech News
2nd April 2009, 01:17 PM #2
Follows Michaels advice
2nd April 2009, 02:14 PM #3
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
2nd April 2009, 02:27 PM #4
Are you on a vanilla network or ?
2nd April 2009, 02:41 PM #5
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.
2nd April 2009, 02:51 PM #6
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*
2nd April 2009, 02:59 PM #7
The template you need to add is Word11.
2nd April 2009, 03:02 PM #8
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!
2nd April 2009, 03:05 PM #9
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
2nd April 2009, 03:22 PM #10
I did it Michael's way and it was really simple to do....just cant remember how i did it!! lol
3rd April 2009, 12:01 PM #11
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 12:10 PM.
3rd April 2009, 12:07 PM #12
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.
I'm sorry but I have definitely installed the ork tools and there doesnt seem to be a template for word11, only office11
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?
3rd April 2009, 12:28 PM #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?
3rd April 2009, 01:03 PM #14
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?
3rd April 2009, 01:10 PM #15
Because the excel/office settings are set per user, each settings stored in users profiles. (I think)
By Little-Miss in forum Office Software
Last Post: 23rd March 2009, 04:37 PM
By garethedmondson in forum Office Software
Last Post: 27th January 2009, 01:06 AM
By Oops_my_bad in forum Windows
Last Post: 24th February 2008, 08:37 PM
By Midget in forum Windows
Last Post: 24th January 2007, 06:07 PM
Last Post: 29th June 2005, 01:43 PM
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)