atw: Re: Help with Word - VBA
- From: Nikki Ward <ezistep@xxxxxxxxxxx>
- To: <austechwriter@xxxxxxxxxxxxx>
- Date: Thu, 9 Nov 2006 14:25:17 +1000
Hi Debbie,
I experienced a similar problem too. I did review my security settings but I
also found that once a macro was disabled, that was pretty much it.
Then suddenly it came back again and I was able to use it. Sometimes this
happens when there are multiple instances of word running in task manager -
stop these processes if Word is closed and the process is still running.
But the most reliable way of getting rid of the problem for good is to
digitally sign your macros.
Sometimes you may have to tick the box that comes up with the 'trust this
macro' dialog box to always trust the macro - really stop and read that
message.. i know I read it 1000 times before i saw the checkbox to 'trust' the
macro. That is fine if it only runs on your machine but if you are going to
deploy that macro then you will get that message again and again. Default
security setting in Word is High in most businesses as part of their SOE so you
have to work with that.
Digital certificates involve some company investment in that they have to
'purchase' digital certs... which is not always included in the budget.
hope the helps,
Cheers
Nikki
________________________________
> To: austechwriter@xxxxxxxxxxxxx
> Subject: atw: Re: Help with Word - VBA
> From: Charles_Boyle@xxxxxxxxxx
> Date: Tue, 31 Oct 2006 08:44:32 +1000
>
> Well that's a bit bizarre. I do know there are some with Outlook + Word
> problems,
> possibly related to one of the inumerable patches (band aids) that get
> slapped all over the products. It may be worth keeping in mind
> that the same thing could happen again when you transfer it to your SOE at
> work - as it is (some form) of security issue. If you are going to
> be running the macros over your network, try to grab some time with the
> network/admin guys and talk it over, quite often they know of all the weird
> security issues caused by the latest....Ahem "upgrades" and you can work
> something out.
> Best wishes,
> Charles Boyle
> "Debbie Hope" <Debbie.Hope@xxxxxxxxxxxxx>
> Sent by: austechwriter-bounce@xxxxxxxxxxxxx
> 31/10/2006 07:40 AM
> Please respond to
> austechwriter@xxxxxxxxxxxxx
> To
> <austechwriter@xxxxxxxxxxxxx>
> cc
> Subject
> atw: Re: Help with Word - VBA
> I tried the below to no avail.
> Laptop I am using is my own. I was trying to successfully write and test
> the macro before I transferred over to my (very large) work
> environment).
> After powering off and on again, starting Outlook and trying to run the
> macro again I still received the error message.
> What fixed it??? Very very odd but everything worked ticky boo after I
> closed Outlook. Unsure why. If I work out a more 'logical' answer to the
> problem I will let you all know. Mind you, nothing is logical with
> Windows and as we all know, NOTHING is logical when it comes to Word. I
> shouldn't be surprised.
> Regards
> Debbie
> -----Original Message-----
> From: austechwriter-bounce@xxxxxxxxxxxxx
> [mailto:austechwriter-bounce@xxxxxxxxxxxxx]
> Sent: Monday, 30 October 2006 3:18 PM
> To: austechwriter@xxxxxxxxxxxxx
> Subject: atw: Re: Help with Word - VBA
> It's to do with your security settings in Word.
> Go to Tools>Macro>Security and choose Medium instead of High or Very
> High.
> Then next time you open the file it will ask if you want to run the
> macros.
> Probably your Word at home is not as secure as at work.
> -----Original Message-----
> From: austechwriter-bounce@xxxxxxxxxxxxx
> [mailto:austechwriter-bounce@xxxxxxxxxxxxx] On Behalf Of Debbie Hope
> Sent: Monday, 30 October 2006 2:55 PM
> To: austechwriter@xxxxxxxxxxxxx
> Subject: atw: Help with Word - VBA
> Hi everyone
> Am a VBA newbie!
> I have created a (Word) macro that I ran a couple of times (against a
> test document) over the weekend without any problems. Today when I try
> to run the macro I receive the following error message:
> 'The Macros in this project are disabled, please refer to the online
> help for this application (blah blah) for instruction on how to enable
> macros'.
> (of course I cannot find anything in the Word online Help - I guess that
> it is probably referring to the VBA online Help?
> Would very much appreciate assistance on this one from a Word/VBA guru
> out there!
> Regards
> ```Debbie```
> **************************************************
> To post a message to austechwriter, send the message to
> austechwriter@xxxxxxxxxxxxxx
> To subscribe to austechwriter, send a message to
> austechwriter-request@xxxxxxxxxxxxx with "subscribe" in the Subject
> field.
> To unsubscribe, send a message to austechwriter-request@xxxxxxxxxxxxx
> with "unsubscribe" in the Subject field.
> To search the austechwriter archives, go to
> www.freelists.org/archives/austechwriter
> To contact the list administrator, send a message to
> austechwriter-admins@xxxxxxxxxxxxx
> **************************************************
> **************************************************
> To post a message to austechwriter, send the message to
> austechwriter@xxxxxxxxxxxxxx
> To subscribe to austechwriter, send a message to
> austechwriter-request@xxxxxxxxxxxxx with "subscribe" in the Subject
> field.
> To unsubscribe, send a message to austechwriter-request@xxxxxxxxxxxxx
> with "unsubscribe" in the Subject field.
> To search the austechwriter archives, go to
> www.freelists.org/archives/austechwriter
> To contact the list administrator, send a message to
> austechwriter-admins@xxxxxxxxxxxxx
> **************************************************
> **************************************************
> To post a message to austechwriter, send the message to
> austechwriter@xxxxxxxxxxxxxx
> To subscribe to austechwriter, send a message to
> austechwriter-request@xxxxxxxxxxxxx with "subscribe" in the Subject field.
> To unsubscribe, send a message to austechwriter-request@xxxxxxxxxxxxx with
> "unsubscribe" in the Subject field.
> To search the austechwriter archives, go to
> www.freelists.org/archives/austechwriter
> To contact the list administrator, send a message to
> austechwriter-admins@xxxxxxxxxxxxx
> **************************************************
> ________________________________
> Note:
> This message is for the named person's use only. It may contain
> confidential, proprietary or legally privileged information. No
> confidentiality or privilege is waived or lost by any mistransmission. If
> you receive this message in error, please immediately delete it and all
> copies of it from your system, destroy any hard copies of it and notify the
> sender. You must not, directly or indirectly, use, disclose, distribute,
> print, or copy any part of this message if you are not the intended
> recipient. BEELINE Technologies and any of its subsidiaries each reserve the
> right to monitor all e-mail communications through its networks.
> Any views expressed in this message are those of the individual sender,
> except where the message states otherwise and the sender is authorized to
> state them to be the views of any such entity.
> Thank You.
> ________________________________
> ________________________________
> This e-mail message has been scanned for Viruses and Content and cleared by
> MailMarshal - For more information please visit
> www.marshalsoftware.com<http://www.marshalsoftware.com>
> ________________________________
**************************************************
To post a message to austechwriter, send the message to
austechwriter@xxxxxxxxxxxxxx
To subscribe to austechwriter, send a message to
austechwriter-request@xxxxxxxxxxxxx with "subscribe" in the Subject field.
To unsubscribe, send a message to austechwriter-request@xxxxxxxxxxxxx with
"unsubscribe" in the Subject field.
To search the austechwriter archives, go to
www.freelists.org/archives/austechwriter
To contact the list administrator, send a message to
austechwriter-admins@xxxxxxxxxxxxx
**************************************************
Other related posts: