[MS Office - 2003] Enabling Macro's

[Little-Miss]

Right, ive been messing with a word doc adding text boxes and whatever to stop the teachers writing essays. I was told i also needed a way for them to be able to add a tick in a box without faffing with fonts. So i created a really simple macro so when a button is pressed a tick is placed.
Now i did this on my laptop which isnt part of the domain. Now i've tried to add it to a networked pc its shouting at me about security and wont let me run it.
I've used selfcert to sign it but that didnt make a difference.

Is the certificate a file somewhere that has to be kept with the doc?
How do i get around this? Do i have to change something in the policys?

Grrr....me trying to be clever...tut

[matt40k]

There's prob a option in GP, I think if you go into macro security, you want to set it to low or something.

If you want to sign them, it's best to use a certificate from your domain's CA (which you might need to install).

[Michael]

Depending on the version of Office you're using (but I will presume Office 2003), navigate to: Tools > Options > Security > Macro Security. Set it to 'Medium'.

When you open a document, Word will always prompt you what to do. Choose 'Enable' and the document should work as intended. I wouldn't recommend you set it to 'Low' as this is a great way for macro viruses to run undetected.

If you need to set this network wide, you need Ork Tools or Office Resource Kit. This is essentially ADM templates (Group Policy Objects) which allow you to tweak Office as you would Windows.

Add the Word11 template, then navigate to:

User Config > Admin Templates > Microsoft Office Word 2003 > Tools | Macro > Security

Set the policy 'Security Level' to Medium. Job done.

[Little-Miss]

Right, i've done as you've suggested Michael (thank you for given me the opportunity to delve into the unknown! ).

Not worked as of yet. Going to try it again on a machine i havent messed with. I'll be back if it doesnt work.

[Little-Miss]

It didnt work

Still getting the error when i try to run it. Even if i've chosen to enable the macro...

[srochford]

Why don't you just put a check box form field on the page?

I don't have Word 2003 at the moment but this looks like the right info for doing it

No macros to worry about and it just works as users (hopefully!!) expect.

[Domino]

It didnt work

Still getting the error when i try to run it. Even if i've chosen to enable the macro...

Ah, you do need to close and reopen word after making that change...

and also if you've not used roaming profiles for each machine you'll need to do it.

[Little-Miss]

Domino: Did all that, still same error. I would've thought that the changes i made in AD would have done that automatically anyway. Somethings not quite right.

srochford: Did think about that, but its something that's going out to the parents so i dont know how its going to look printed. Might try it and see.

[Michael]

It sounds as though you've done everything correctly. Word should always prompt you whenever a macro enabled document is detected. The problem you have does appear to be related to the document specifically.

The reason I know all the above is primarily to do with an application called 'Nelson Handwriting' which uses macros. Office 2003's default macro setting is high, which is pretty useless as only trusted sources will work.

[Little-Miss]

So you think its the document?

Might start from scratch and try again. Though i have just deleted and recreated the macro because i'd had a dur moment with the original and its still not working

[srochford]

Office 2003's default macro setting is high, which is pretty useless as only trusted sources will work.

Err; that's kind of the idea! You might as well say [insert name of virus scanner] is useless because it blocks bad programs!!

[Little-Miss]

Right, I created a blank test document with the same macro (which i have started from scratch). All the macro is " Letter P > change font to wingdings 2> adjustment of size and that creates the tick.
Tried to open it on a networked w/s. Got the choice to enable the macro, ok fine. Try to run the macro by clicking on the toolbar button i created and get

"The macro cannot be found or has been disabled becayse of your macro security settings."

Grrr

All this for a tick!

[JOrdan01070]

Little Miss go to Insert > symbols. then change the font to windings 2 >select the tick then click on shortcut key, then press on the keys you want to use a the shortcut. to finish make sure you save the changes in the document and not normal.dot then you don't need to use macros.

[Little-Miss]

OMG Jordan you may have saved me so much work!! Going to try it now!

[Little-Miss]

Right, that works perfectly. But when i open the document on another computer the shortcut key isnt working, i was kinda hoping if i save it to the doc it would follow it...

Is it just me!!! lol