View Single Post
  #9   Report Post  
Tom Hyland
 
Posts: n/a
Default

Jay, you are just fantastic ! Unbeliveable. Whiskey for the men and beer for
their horses. This is just wonderful. thank you so very much. tom

"Jay Freedman" wrote:

Hi Tom,

Glad to help. That's what we're here for.

If a form is password protected and you don't know the password, you can't
unprotect it (in theory) so you can't spell-check it.

I said "in theory" because it just ain't so. If you open a new blank
document and use Insert File to insert the form, the result is not
protected and has no password. You could then run the macro on this copy to
spell-check the fields.

--
Regards,
Jay Freedman
Microsoft Word MVP FAQ: http://word.mvps.org

Tom Hyland wrote:
Hi Jay - It worked (Of course you knew that.) I'm assuming that Note
2 at the bottom of the MVP Macro is to work only in those documents
that you have the password for ? Is there any way to spell check a
password protected document where the password is not known ? Can't
thank you enough for your great help, tom.

"Jay Freedman" wrote:

Hi Tom,

Like I said, one step at a time. :-) The dashed line is part of the
stuff youcopied out of the web page, but it isn't something VBA knows
how to use. Just delete the dashed line. VBA will automatically put a
solid line there as a separator between the two subroutines (that is,
End Sub is the end of one subroutine, and Private Sub is the start of
the next one). Also delete any other dashed lines that look like the
first one.