error number 50289

[Ellen]

We recently started experiencing an error in a toolbar that has a button for
creating a customized letterhead, memo or fax cover. We've been using this
toolbar for over a year.

The first error we received is:

Error - Personalize Memorandum Template (7)
Error number 6068

I found a knowledgebase article that had information on this error:

http://support.microsoft.com/default.aspx?scid=kb;en-us;246299

I clicked on the link to another knowledgebase article that indicated
checking the macro security and checking "Trust access to Visual Basic
Project," under tools, macro, macro security, trusted sources.

http://support.microsoft.com/kb/282830/EN-US

Once I made this change, a different error now comes up:

Error - Personalized Memorandum Template (5)
Error number 50289

I have been unable to find anything on this error.

Any ideas as to what this error means. We are using Office XP with SP3.
Could any of the recent security updates for Windows XP or SP3 have broken
VBA?

 

[Jay Freedman]

Google is a wonderful thing... I found two pages:

http://64.233.167.104/search?q=cach...dex.php/t-220638.html+50289++error++vba&hl=en

http://groups-beta.google.com/group/microsoft.public.word.vba.beginners/msg/5c5805ab731f1b4f?hl=en

Both of them identify error 50289 as "Can't perform operation once the
project is protected." That is, your macro is trying to change a VBA project
that's locked with a password. I don't think this has anything to do with
security updates.

You'll have to (a) include the project password in the code of your macro
that opens the template; or (b) request the password from the user before
opening the template -- although they probably won't know what it is; or (c)
change the whole setup so that you don't have to modify any code. The last
is probably the best, but it depends on what you're doing to customize the
template.