Jump to content

Recommended Posts

Posted

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 :getmecoat:

Posted

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).

Posted

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.

  • Thanks 1
Posted

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

 

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. :o

Posted
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.

Posted

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.

Posted

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.

Posted

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

Posted
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!!

Posted

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 :mad:

 

All this for a tick!

Posted

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.

 

:)

  • Thanks 1
Posted

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 :getmecoat:

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now



×
×
  • Create New...