Word VBA >> Win/Word XP *always* asks for Enable - any help?

by Ed » Thu, 29 Jul 2004 01:05:22 GMT

Ever since I was "upgraded" to Windows XP Pro and Word XP, I've tried
unsuccessfully to get Word to recognize my macros on opening. I can not get
a digital signature to stick. I've tried various methods from this NG and
the KB, but no go. Besides just wanting to hit a custom button without
having to enable macros, this really hampers automating from VB6. Any code
trying to open Word for the first time gets hit with the Enable Macros box.
If I have to be there to hit Enable, I've defeated half my automation! Any
suggestions?

Ed




Word VBA >> Win/Word XP *always* asks for Enable - any help?

by Charles Kenyon » Fri, 30 Jul 2004 05:09:04 GMT


Store your code in templates that are in your templates folders or in global
templates that are in your startup folder and set your macro security to
trust code in templates in those locations.
--

Charles Kenyon

Word New User FAQ & Web Directory: http://addbalance.com/word

Intermediate User's Guide to Microsoft Word (supplemented version of
Microsoft's Legal Users' Guide) http://addbalance.com/usersguide

See also the MVP FAQ: http://www.mvps.org/word which is awesome !
--------- --------- --------- --------- --------- ---------
This message is posted to a newsgroup. Please post replies
and questions to the newsgroup so that others can learn
from my ignorance and your wisdom.



get
code
box.
Any





Word VBA >> Win/Word XP *always* asks for Enable - any help?

by Ed » Fri, 30 Jul 2004 07:12:59 GMT

Charles, all of my macros are in Normal.dot, which is stored in
C:\Documents and Settings\UserName\Application Data\Microsoft\Templates.
And my macro security is set to Trust all installed add-ins and templates.
Is this not good enough?

Ed

"Charles Kenyon" < XXXX@XXXXX.COM > wrote in

global


and




Win/Word XP *always* asks for Enable - any help?

by Charles Kenyon » Mon, 02 Aug 2004 22:22:50 GMT

It is good enough. It should not be asking you about these if your security
setting is medium.
--

Charles Kenyon

Word New User FAQ & Web Directory: http://addbalance.com/word

Intermediate User's Guide to Microsoft Word (supplemented version of
Microsoft's Legal Users' Guide) http://addbalance.com/usersguide

See also the MVP FAQ: http://www.mvps.org/word which is awesome !
--------- --------- --------- --------- --------- ---------
This message is posted to a newsgroup. Please post replies
and questions to the newsgroup so that others can learn
from my ignorance and your wisdom.

"Charles Kenyon" < XXXX@XXXXX.COM > wrote in

global


and




Win/Word XP *always* asks for Enable - any help?

by Ed » Tue, 03 Aug 2004 02:38:43 GMT

A closer look, Charles, seems to indicate the problem is one add-in that is
in My Documents. Might putting this in a different folder solve the
problem? Also, I wanted to - for ease of use by others - create a document
on my desktop that had Auto_Open code - no having to launch Word and fish
for the macro any more. Should this be a template rather, and a shortcut to
the desktop?

Ed

"Charles Kenyon" < XXXX@XXXXX.COM > wrote in

security



not
without




Win/Word XP *always* asks for Enable - any help?

by Charles Kenyon » Tue, 03 Aug 2004 13:51:26 GMT

es, put the Add-In in the Start-Up folder, which is a recognized source.
Likewise, you want your AutoOpen macro to be in a template, in the templates
folder (user templates or workgroup templates). You can put a shortcut to
your template on your desktop if you want. Double-clicking on it will create
a new document. If you want your macro to fire when a new document is
created, it should be named AutoNew instead of AutoOpen.

For more on the different kinds of templates and locations of templates
folders see http://addbalance.com/usersguide/templates.htm.

--

Charles Kenyon

Word New User FAQ & Web Directory: http://addbalance.com/word

Intermediate User's Guide to Microsoft Word (supplemented version of
Microsoft's Legal Users' Guide) http://addbalance.com/usersguide

See also the MVP FAQ: http://www.mvps.org/word which is awesome!
--------- --------- --------- --------- --------- ---------
This message is posted to a newsgroup. Please post replies
and questions to the newsgroup so that others can learn
from my ignorance and your wisdom.

"Ed" < XXXX@XXXXX.COM > wrote in message
news: XXXX@XXXXX.COM ...
is
document
to
to
tried
NG
Any
Macros
automation!




Win/Word XP *always* asks for Enable - any help?

by Ed » Tue, 03 Aug 2004 21:11:05 GMT

hanks, Charles. Problems are solved! (Wish they were _all_ that easy!)

Ed

"Charles Kenyon" < XXXX@XXXXX.COM > wrote in
message news: XXXX@XXXXX.COM ...
templates
create
fish
shortcut
in
security
can
this




Similar Threads

1. Office 2k install on win xp pro sp1a System asks for SP1 CD - MS Office Setup

2. Re-installed Office XP and always asks to agree to license

I have had to re-install ofiice XP pro and even though I 
have registered again with Microsoft every time I open 
Excel, Word of any other of the office programs I am 
forced to agree to the license. When I agree I can sue 
the program but to always have to click the agree button 
is annoying.
Any help will be greatly appreciated.
Brian

3. Office XP SP1 and SP2 Updates always ask to accept EULA

4. EngraversGothic BT looks different on Win XP / Word 2007 than Win 2K / Word 2K

5. TOC for multiple documents - Please help - Word 2000, Win XP Pro - Word Document management

6. RASENTRY and dwfOptions2 in Win XP Need Help!

Hi,

I have Win XP Professional Polish wersion. I try to write some code in
VC++.NET for disable programmaticaly Negotiate multilink for single-link
connection but I can;t compile it because the compiler says that the version
is incorrect. I put the code like: WINVER >= 0x0501 and than compiler works
great but I know that XP support Negotiate multilink but after when I run my
code, it's like this version of the OS don't support this option or my RAS.h
don't let use this option. I really don't know where is the problem
Please help me.

Silvester
/_cut_this_/smadej(at)slycom (dot) net


7. HELP WordPerfect 8 accessories not working in Win XP

8. Win 2K and Win XP compatibility with Outlook COM Addin

Hi everybody!

I am developing a COM AddIn in Visual Basic 6.0 for Outlook 2000 which
is supposed to work in Outlook 2000 with the Windows 2000 operating
system.

The main thing that the AddIn does is to create a button
(Office.CommandBarButton) in the email reading window (on its
Inspector) and do some work when that button is clicked.

The problem is: the Addin works fine in Outlook 2000, under Windows
XP, but it doesn't work at all in Outlook 2000 under Windows 2000!
Under Win 2000, although the COM AddIn can be seen registered on the
COM AddIns dialog box, in Outlook 2000, the button never shows up.

I have tried it in all these different situations:
- compiling the dll and registering it straight from Visual Studio
(under Win XP): it works.
- using the setup package, created with the Package and Development
Wizard, creating it under Win XP: works when installed in Win XP but
doesn't work when installed in Win 2000.
- compiling the dll and registering it straight from Visual Studio
(under Win 2000): it doesn't work.
- using the setup package, created with the Package and Development
Wizard, creating it under Win 2000: doesn't work when installed in Win
2000 and also doesn't work when installed in Win XP.

The references I am using in this VB project are:
- Visual Basic for Applications (msvbvm60.dll)
- Visual Basic runtime objects and procedures (msvbvm60.dll\3)
- Visual Basic objects and procedures (VB6.OLB)
- OLE Automation (stdole2.tlb)
- Microsoft Add-In Designer (MSADDNDR.DLL)
- Microsoft Outlook 9.0 Object Library (MSOUTL9.OLB)
- Microsoft Office 9.0 Object Library (MSO9.DLL)
- Microsoft CDO 1.21 Library (CDO.DLL)
- Microsoft Scripting Runtime (scrrun.dll)

All the above system files that are needed to be referenced are found
both in Windows 2000 and XP, so I really don't understand why it is
working in Outlook 2000, under Windos XP, but not in outlook 2000
under Windows 2000. It also works in Outlook XP, under Windows XP.

Note, I am using:
- the Outlook COM AddIn template, by MicroEye.
- Windows 2000 Professional and Windows XP Professional.
- Microsoft Visual Studio 6.0, with Service Pack 4 installed.

Thanks in advance, for all your help.