Is there a way to lock/password protect formfields so that no more
information can be added/changed?
All help is appreciated

I have a userform with various related procedures. My question is
this:
1. if I make all my declarations in the first executed procedure do
they hold good fro all the procedures or do i need to declare them in

I have user form that has a textbox on it (.txtPhone), I want to validate
that the data is all numbers and if not, display message box "Text Only" and
then have the focus stay in the text box.
I currently can validate if .txtPhone ISNumeric (see code below), but I can

I need to prepare a Word template, containing macros, for use on other PCs.
I cannot see another way of running a macro other than going to
Tools/Macro/Macros.
In Excel I could assign a macro to a object but I cannot see how to do that

I have a template that has a macro to save the document. The macro is on the
toolbar.
The document saves and closes per command but, the application.quit does not
close word.

Is it possible to suppress the dotted underline indicating hidden text?
I am using hidden text in templates to hold user instructions.  The dots
make it difficult to read.

Gerus,
I developed a toolbar in Word 2003 with 25 buttons.  When it is placed
in Word 2007, it produces a mile-long ribbon and the user has to click
the right/left arrows to view the other half of the ribbon.  Is their

In a VSTO project I want to be able to capture every keystroke and be given
control in my C# code so I can make a decision on what to do.
Such as somebody hits the space bar I want to insert a "Happy face".  Or if
someone selects and hits the delete key, I get to intercept the ...

Is it possible to create a drag and VBA Word application that is drag
and drop.  I wish to take a text file and drop it into the desktop
icon where it will be inserted to template and then spit out two
files, one as a *.doc and the other as a *.pdf document.  Double

Hi, I'm cross-posting with a vengeance attempting to solve a problem.
I have a log file, that I'm trying to use macros to reformat and segregate
into seperate files. All my subs except one work.
Sub ConvertParagraphs2LineFeeds()

I have created a template (.DOT) and in the template I have created two new
menus. I have then copied the template into the Word STARTUP folder so that
the two new menus will be added when opening Word.
The strange part is that when I open up Word only one of the menus are

Could someone confirm if I use this:
ActveDocument.Fields.Update
Will it update the fields in the headers and footers or do I have to
do something special?

I have a text file that has information as follows:
Start Date  End Date  Event name
1/1/2007    1/5/2007  Inauguration ceremony
2/5/2007    2/9/2007  Camping

I have a document that a large ammount of different teams are going to use,
and the data on this document will be pulled into the access database. Since
multiple versions of the same form could come in, I need to have a Unique
Identifier so I can read the correct form when it comes ...

I am following jay Freedman's advice about structuring my modules. I
have a user form and a module that will update some of the document
properties and save the file. My question relates to the user
selecting the Cancel button. I am hiding the form in the form Cancel