Macro warning frustration

[Robert McN]

Yesterday, I unsuccessfully tried to set up a text-to-speech macro. It was
for general use in Word, but after over an hour or so, gave up. Since then,
I have found that the text that happened to be open, which is a very long
chapter in a Ph.D. dissertation (about 100 pages), is associated with this
macro. Every time I try to open the file, I get an error message, "File "x"
contains macros. Macros may contain viruses. it is usually safte to disable
macros, but if the macros are legitimate, you might lose some functionality."
It doesn't matter if I press enable or disable, the next time I open the
document, the error message appers again. I tried to delet the macros, and
the program won't allow me to delete them. I went to Alt-F8 selected the
offending macros and pressed delete. I got an error message, "Compile Error:
User-defined type not defined." and after exiting & restarting the program,
the offending macros are still there and I continue to get the irritating
message about macros when I open the file. Does anyone know how can I get
the file to open without crazines? Thanks. Bob

 

[Doug Robbins]

And of course, being a Ph.D dissertation, you don't have a back up of it?

If you save the document in .RTF format, then close it and then re-open it
in Word, the macros will be stripped from. Unfortunately you may also loose
some formatting.

--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

 

[Robert McN]

When asked if this answered the problem I clicked "no," but perhaps I should
have clicked "yes." I tried what you suggested and it worked. But the
questions remains: 1) why can't I get rid of the irritating warning? There
are no problematic macro. 2) I'd rather stay with the Word document to avoid
losing any of the formatting.
In any case, thanks very much. You did provide a "work-around" and for that
I am most grateful.
Bob
PS: I do have backups. But I believe the problem appears on the backups,
because I back up almost every hour and I didn't realize I had the problem
until I closed the program down and restarted the next day.

 

[Jonathan West]

When asked if this answered the problem I clicked "no," but perhaps I
should
have clicked "yes." I tried what you suggested and it worked. But the
questions remains: 1) why can't I get rid of the irritating warning?
There
are no problematic macro.

There were macros in it once, and even when the macros are deleted, the flag
in the document indicating that macros are present is not cleared.

2) I'd rather stay with the Word document to avoid
losing any of the formatting.
In any case, thanks very much. You did provide a "work-around" and for
that
I am most grateful.

Most for the formatting should be kept. It would take some serious
complexity (rather than just mere file size) for you to lose anything
significant.

--
Regards
Jonathan West - Word MVP
www.intelligentdocuments.co.uk
Please reply to the newsgroup
Keep your VBA code safe, sign the ClassicVB petition www.classicvb.org

 

[Robert McN]

I understand your response and as above, please accept my thanks. But still,
my question remains: is there some way just to tell the program, "Yes, there
are macros, but don't worry about them. They are ok." The point is I might
want to keep the macros, but not be forever warned about them. It seems to
me that i should be able to tell the program once, "OK" and thereafter, be
able to use the file without being warned. And I want to be able to do so
without lowering my security settings (which now are set at medium.) Whatever
your response, I'll stop my questioning regarding this matter here.
Thanks again.

 

[Jonathan West]

Ah, I had misunderstood. I had been under the impression that the macros
were there once and that you had removed them but were still getting the
warning.

If you have macros in the document that you want to keep, then that is a
different matter.

Probably the simplest way of getting rid of the warning is to make yourself
a digital signature. See if you have a program called selfcert.exe installed
(it comes as part of Office, but it is an optional component, so it isn't
necessarily on your machine. Use selfcert to create a digital siggnature and
sign the VBA project with the signature. On your own PC at least, the
warnings will no longer appear

--
Regards
Jonathan West - Word MVP
www.intelligentdocuments.co.uk
Please reply to the newsgroup
Keep your VBA code safe, sign the ClassicVB petition www.classicvb.org

 

[Doug Robbins]

Set the Macro Security Level to High

--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP