Test Your Skills with Microsoft Office Quizzes !!

Office Quizzes

All Microsoft Office quizzes are are available from the link below. If you're feeling quizzical, this is the place. Don't be afraid to be tested on everything you think you know about Microsoft Office — and aren't afraid to be asked.

Please follow the link to enjoy and test your skills http://office.microsoft.com/en-us/help/FX100485331033.aspx

Have you ever wanted to do more than use the basic find-and-replace functions in Word? Wildcard characters and regular expressions can make those oper

By Colin Wilcox,
Graham Mayor, and Klaus Linke

Applies to
Microsoft Word 97, 2000, and 2002

Have you ever had to make a large number of repetitive changes to a document by hand? For example, have you ever had to find and remove duplicate rows from a large table, or transpose a list of names (change them from "Colin Wilcox" to "Wilcox, Colin")? That type of repetitive find-and-replace work gets old in a big hurry, doesn't it?
You can automate many of those find-and-replace tasks. Microsoft Word provides a set of wildcard characters that you can use to build regular expressions, combinations of literal text and wildcard characters. You can use regular expressions to find text that matches a given pattern and then replace those matches with new text.
If this all sounds complex, don't worry. We'll introduce it in easy steps, explain things as we go, and provide several working examples. You can use the information in this column with Word 97, 2000, and 2002. The user interfaces vary slightly between the versions, but you can accomplish the tasks described here with each version.

A quick spin through the jargon
To start, let's define a couple of terms:
A wildcard character is a keyboard character that you can use to represent one or many characters. For example, the asterisk (*) typically represents one or more characters, and the question mark (?) typically represents a single character.
In our case, a regular expression is a combination of literal and wildcard characters that you use to find and replace patterns of text. The literal text characters indicate text that must exist in the target string of text. The wildcard characters indicate the text that can vary in the target string.
That may seem a bit abstract, but you've seen (and most likely used) wildcard characters and regular expressions since you first began computing. For example, the Open dialog box (on the File menu, click the Open command) uses the asterisk wildcard character extensively: And, if you ever used the MS-DOS operating system, you probably used a command and a simple regular expression to copy files:
copy *.doc a:
That command uses the asterisk wildcard character and the .doc literal text string to copy a set of Word documents to hard disk drive A. If you look around a bit, you'll see that Microsoft Windows® and the Microsoft Office applications use wildcard characters everywhere.
Try it!
The steps in this section explain how to use a regular expression that transposes names. Keep in mind that you always use the Find and Replace dialog box to run your regular expressions. Also, remember that if an expression doesn't work as expected, you can always press CTRL+Z to undo your changes, and then try another expression.
To transpose names
Start Word and open a new, blank document.
Copy this table and paste it into the document.
Josh Barnhill
Doris Hartwig
Tamara Johnston
Daniel Shimshoni
Press CTRL+F to open the Find and Replace dialog box.
If you don't see the Use wildcards check box, click More, and then select the check box. If you don't select the check box, Word treats the wildcard characters as text.
Click the Replace tab, and then enter the following characters in the Find what box. Make sure you include the space between the two sets of parentheses: (<*>) (<*>)
In the Replace with box, enter the following characters. Make sure you include the space between the comma and the second slash: \2, \1
Select the table, and then click Replace All. Word transposes the names and separates them with a comma, like so:
Barnhill, Josh
Hartwig, Doris
Johnston, Tamara
Shimshoni, Daniel
At this point, you may wonder what to do if some or all of your names contain middle initials. See the first example in Putting regular expressions to work in Word for more information.
The next section explains how those regular expressions work.
What makes the expression tick
From here on, keep this principle in mind: The content of a document controls most (but not all) of the design of your regular expressions. For example, in the sample table you used earlier, each cell contained two words. If the cell contained two words and a middle initial, you'd use a different expression.
Let's examine each expression from the inside out:
In the first expression, (<*>) (<*>):
The asterisk (*) returns all the text in the word.
The less than and greater than symbols (< >) mark the start and end of each word, respectively. They ensure that the search returns a single word.
The parentheses and the space between them divide the words into distinct groups: (first word) (second word). The parentheses also indicate the order in which you want search to evaluate each expression.
In other words, the expression says: "Find both words."
Note Searching on this expression, (*) (*>), produces the same results. However, the expression in the example is easier to describe, and you should use restricting characters whenever you can, because doing so ensures greater accuracy in your results.
In the second expression, \2, \1:
The slash (\) works with the numbers to serve as a placeholder. (You can also use the slash to find other wildcard characters. See the next section for more information.)
The comma after the first placeholder inserts the correct punctuation between the transposed names.
In other words, the expression says: "Write the second word, add a comma, write the first word."

For more on this issue please follow this link :http://office.microsoft.com/en-us/word/HA010873051033.aspx

Track activity on a workbook by using Microsoft Outlook

Add a task for a workbook to your Outlook task list
To do this procedure, make sure that

1.Open the workbook you want to add a task for in the Outlook task list.
2.On the Reviewing toolbar, click Create Microsoft Outlook Task .
3.Select the options you want, and then click Save and Close .

Create a new task request

1. Start Outlook.
2. On the File menu, point to New, and then click Task Request.
3. In the To box, enter the name of the person you want to assign the task to.
To select the name from a list, click the To button.
4. In the Subject box, type a task name.
5. Select the due date, status, and priority options you want.
6. Select or clear the Keep an updated copy of this task on my task list check box and the Send me a status report when this task is complete check box.
7. If you want the task to repeat, click the Actions menu, click Recurrence, select the options you want, and then click OK.
For Help on an option, click the question mark , and then click the option.
8. In the text box, type instructions or information about the task.
9. Click Send .

Its simply great for those who are in need!!

Thanks to Microsoft Document Imaging TooL

These steps will assist you in using Microsoft Office 2003's built in scanning capabilities for text recognition (OCR or Optical Character Recognition).

Microsoft Office Document Imaging has two components: a scanning component and an imaging component. These are listed separately in the Microsoft Office Tools menu as Microsoft Office Document Scanning and Microsoft OfficeThanks to Microsoft Document Imaging TooL
These steps will assist you in using Microsoft Office 2003's built in scanning capabilities for text recognition (OCR or Optical Character Recognition).

Click on the image to view full size

Microsoft Office Document Imaging has two components: a scanning component and an imaging component. These are listed separately in the Microsoft Office Tools menu as Microsoft Office Document Scanning and Microsoft Office Document Imaging. Microsoft Office Document Scanning can control any installed scanner and uses the scanner's scanning presets. For example, the Black and white scanning preset is ideal when scanning pages of text for OCR. The Color scanning preset is best for scanning full-color pictures or artwork. Microsoft Office Document Imaging allows you to view scanned documents on the screen, rearrange multi-page documents, select and manipulate recognized text, annotate scanned documents and electronic faxes, and send documents to others by e-mail or fax. Document Imaging may be a better choice for new users to get started. You see the Microsoft Office Document Imaging application window from the start.

If you choose the Document Scanning choice, you only see the Document Imaging application window after the scan completes. How to perform OCR with Microsoft Office 2003 Document Imaging Connect your scanner. Place a page of text in the scanner. Document Imaging. Microsoft Office Document Scanning can control any installed scanner and uses the scanner's scanning presets. For example, the Black and white scanning preset is ideal when scanning pages of text for OCR. The Color scanning preset is best for scanning full-color pictures or artwork. Microsoft Office Document Imaging allows you to view scanned documents on the screen, rearrange multi-page documents, select and manipulate recognized text, annotate scanned documents and electronic faxes, and send documents to others by e-mail or fax. Document Imaging may be a better choice for new users to get started. You see the Microsoft Office Document Imaging application window from the start. If you choose the Document Scanning choice, you only see the Document Imaging application window after the scan completes. How to perform OCR with Microsoft Office 2003 Document Imaging Connect your scanner. Place a page of text in the scanner.

Click on the image to view full size

• Click Start, >
• --------------->All Programs,
• ------------------------->Microsoft Office,
• -------------------------->Microsoft Office Tools,
• --------------> and then Microsoft Office Document Imaging.

NOTE: To see the OCR options, click the Tools menu and choose Options. Click the OCR tab. The default settings are recommended. Click OK.

> From the File menu choose Scan New Document.
Click the Scanner button. > Choose the driver for the scanner. It will likely be a TWAIN driver. Again, the defaults should be fine. If the process fails and the scanner is not recognized, if you have a 2nd option here, change to that driver and try again. Click OK.
For OCR, select either Black and white or Black and white from color page depending on the type of text you are scanning.

NOTE: If you want to change the Presets or have other Custom settings (need to scan Legal pages), click the Preset options drop down menu. Choose the desired choice. You can edit the paper size, where the files are saved, etc.
If you have multiple pages to scan, click the Prompt for Additional pages checkbox. If you only have a single page, un-check it.

NOTE: Please leave the View file after scanning box choice selected.
>Click the Scan button when ready to proceed.

If you choose the "Prompt for Additional pages" checkbox, place the next page in the scanner. Click Continue. Repeat this as needed until all pages are scanned. Click Done when complete.

NOTE: What you will see on the screen is a TIF or image file. Word cannot these files as TIF's.
From the Tools menu choose Send Text to Word or click the Send Text to Word button on the toolbar.
You can send all pages or just the selected pages to Word. You can also choose to have the pictures included in the Word document as well. To change where the Word file will be created, click the Browse button and choose the desired folder.
Click OK when ready.
The document will be opened in Word.

> Go to the File menu and choose Save As. Save the file as a .DOC file rather than a .HTM file.
Final Thoughts:The page layout structure will not be maintained. But you will have the text.
Instead of Paragraph returns between the lines you will have manual line breaks. You can use Word's Replace command from the Edit menu to change these. Use the following in the Find and Replace boxes.

Find what: ^l Replace with: ^p
Once you finish cleaning up the formatting, you will have your OCR document. All with a built-in Office 2003 feature.

Power Point Presentation are even look nice without much animation!!

Hi deareader, hope you will find this post helpful. If you make presentations in Power Point frequently or on regular basis you will want to add more animation on each slide so as to make the presentation look dynamic and even more attractive. If you do so you might come across a problem that you may ignore. Giving animation doesnt help you make a good presentation instead it will slow down your presentation's performance. So remember these points you cover important points necessary description and cool picture for demonstration on each slide apply no animation or slide transition to your slides because it needs more memory and thus slow down the process. So what you have to do is remove animation and remove slide transition and make plane cool presentation and check its performance it will run like a horse even on low configuration systems. So you can notice some standard and dynamic presentation style in such slide shows where there very less animation used. So i think its better idea to avoid using animation in slides. This will let you create as many as slides in a single power point file. So enjoy this idea by using it practically. For more queries on this feel free to write me @ w.xl.tech@gmail.com

Word mail merge

Applies to
Microsoft Office Word 2003
Microsoft Word 2002



Mail merge step 1: Choose a document type and main document

Show All
Hide All
Applies to
Microsoft Office Word 2003
Microsoft Word 2002
Overview of the Word mail-merge process
Step 1: Choose a document type and main document
Step 2: Connect to a data file and select records
Step 3: Add fields to the main document
Step 4: Preview the merge and then complete it

This step in the mail-merge process involves two choices. First, you choose the type of document that you want to merge information into. Then, you choose the main document that you want to use. The main document is the document that you start with. It's the model for all of the merged documents that you eventually create.
Note Remember, we're using form letters as the example in this article series. If you are creating a set of merged labels or envelopes, the process is a little different. To go directly to information about labels or envelopes, click a link in the See Also section of this column.
Choose the type of document you want to merge information into
The Mail Merge task pane opens with a question about what type of merged document you are creating. After you choose, click Next at the bottom of the task pane.
Note If you don't see the Mail Merge task pane, on the Tools menu, point to Letters and Mailings, and then click Mail Merge (or Mail Merge Wizard, if you're using Word 2002).
If you have fax support set up on your computer and a fax modem installed, you will also see Faxes in the list of document types.
Choose the main document you want to use
If your main document (called the starting document in the task pane) is already open, or you are starting with a blank document, you can click Use the current document.
Otherwise, click Start from a template or Start from existing document, and then locate the template or document that you want to use.

Microsoft Word shortcut keys

Microsoft Word shortcut keys
Below is a listing of all the major shortcut keys in Microsoft Word. See our main shortcut page if you're looking for other shortcut keys used in other programs.
Shortcut Keys -----------------------------------------Description
Ctrl + A--------------------------Select all contents of the page.
Ctrl + B--------------------------Bold highlighted selection.
Ctrl + C--------------------------Copy selected text.
Ctrl + X -------------------------Cut selected text.
Ctrl + P--------------------------Open the print window.
Ctrl + F--------------------------Open find box.
Ctrl + I--------------------------Italic highlighted selection.
Ctrl + K--------------------------Insert link.
Ctrl + U--------------------------Underline highlighted selection.
Ctrl + V--------------------------Paste.
Ctrl + Y--------------------------Redo the last action performed.
Ctrl + Z--------------------------Undo last action.
Ctrl + L--------------------------Aligns the line or selected text to the left of the screen.
Ctrl + E--------------------------Aligns the line or selected text to the center of the screen.
Ctrl + R--------------------------Aligns the line or selected text to the right of the screen.
Ctrl + M-------------------- -----Indent the paragraph.
Ctrl + Shift + F-------------------Change the font.
Ctrl + Shift + >-------------------Increase selected font +1pts up to 12pt and then increases font +2pts.
Ctrl + ]---------------------------Increase selected font +1pts.
Ctrl + Shift + --------------------Decrease selected font -1pts if 12pt or lower, if above 12 ----------------------------------------decreases font by +2pt.
Ctrl + [--------------------------Decrease selected font -1pts.
Ctrl + Shift + *------------------View or hide non printing characters.
Ctrl + ---------------------------Moves one word to the left.
Ctrl + ---------------------------Moves one word to the right.
Ctrl + ---------------------------Moves to the beginning of the line or paragraph.
Ctrl + ---------------------------Moves to the end of the paragraph.
Ctrl + Del------------------------Deletes word to right of cursor.
Ctrl + Backspace-----------------Deletes word to left of cursor.
Ctrl + End-----------------------Moves the cursor to the end of the document.
Ctrl + Home---------------------Moves the cursor to the beginning of the document.
Ctrl + Spacebar------------------Reset highlighted text to the default font.
Ctrl + 1--------------------------Single-space lines.
Ctrl + 2--------------------------Double-space lines.
Ctrl + 5--------------------------1.5-line spacing.
Ctrl + Alt + 1---------------------Changes text to heading 1.
Ctrl + Alt + 2---------------------Changes text to heading 2.
Ctrl + Alt + 3---------------------Changes text to heading 3.
Ctrl + F1-------------------------Open the Task Pane.
F1--------------------------------Open Help.
Alt + Ctrl + F2--------------------Open new document.
Ctrl + F2-------------------------Display the print preview.
Shift + F3------------------------Change the text in Microsoft Word from upper to lower case or a capital letter at the beginning of every word.
Shift + Insert---------------------Paste.
F4--------------------------------Repeat the last action performed (Word 2000+)
F5--------------------------------Open the find, replace, and go to window in Microsoft Word.
Ctrl + Shift + F6------------------Opens to another open Microsoft Word document.
F7--------------------------------Spell and grammar check selected text and/or document.
Shift + F7-------------------------Runs a Thesaurus check on the word highlighted.
F12-------------------------------Save as.
Shift + F12------------------------Save.
Ctrl + Shift + F12------------------Prints the document.
Alt + Shift + D---------------------Insert the current date.
Alt + Shift + T---------------------Insert the current time.
In addition to the above shortcut keys users can also use their mouse as a method of quickly do something commonly performed. Below some are examples of mouse shortcuts.
Mouse shortcuts
Description
Click, hold, and drag
Selects text from where you click and hold to the point you drag and let go.
Double-click------------If double-click a word, selects the complete word.
Double-click------------Double-clicking on the left, center, or right of a blank line will make the alignment of the text left, center, or right aligned.
Double-click------------Double-clicking anywhere after text on a line will set a tab stop.
Triple-click-------------Selects the line or paragraph of the text the mouse triple-clicked.
Ctrl + Mouse wheel-----Zooms in and out of document.

Protect a document from unauthorized changes

Seal your document with a digital certificate
You digitally sign (digital signature: An electronic, encryption-based, secure stamp of authentication on a macro or document. This signature confirms that the macro or document originated from the signer and has not been altered.) a file or a macro project (macro project: A collection of components, including forms, code, and class modules, that make up a macro. Macro projects created in Microsoft Visual Basic for Applications can be included in add-ins and in most Microsoft Office programs.) by using a digital certificate (digital certificate: Attachment for a file, macro project, or e-mail message that vouches for authenticity, provides secure encryption, or supplies a verifiable signature. To digitally sign macro projects, you must install a digital certification.).
If you don't already have a digital certificate, you must obtain one.
How?
You can obtain a digital certificate from a commercial certification authority, such as VeriSign, Inc., or from your internal security administrator or Information Technology (IT) professional. Or, you can create a digital signature yourself using the Selfcert.exe tool.
To learn more about certification authorities that offer services for Microsoft products, see the Microsoft Security Advisor Web site.
Note Because a digital certificate you create yourself isn't issued by a formal certification authority, macro projects signed (digital signature: An electronic, encryption-based, secure stamp of authentication on a macro or document. This signature confirms that the macro or document originated from the signer and has not been altered.) by using such a certificate are referred to as self-signed projects. Depending on how Microsoft Office digital-signature features are being used in your organization, you might be prevented from using such a certificate, and other users might not be able to run self-signed macros for security reasons.
On the Tools menu, click Options, and then click the Security tab.
Click Digital signatures.
Click Add.
Select the certificate you want to add, and then click OK.
Require a password to open or modify a document
Security Use strong passwords that combine upper- and lowercase letters, numbers, and symbols. Weak passwords don't mix these elements. Strong password: Y6dh!et5. Weak password: House27. Use a strong password that you can remember so that you don't have to write it down.
Open the file.
On the Tools menu, click Options, and then click Security.
Do one of the following:
Create a password to open
In the Password to open box, type a password, and then click OK.
In the Reenter password to open box, type the password again, and then click OK.
Create a password to modify
In the Password to modify box, type a password, and then click OK.
In the Reenter password to modify box, type the password again, and then click OK.
Tip
To create a long password— up to 255 characters— click Advanced, and select an RC4 encryption type.
Have Microsoft Word recommend opening a document as read-only
You can suggest, but not require, that users open a document as read-only (read-only: A setting that allows a file to be read or copied, but not changed or saved. If you change a read-only file, you can save your changes only if you give the document a new name.). If a user opens the document as read-only and changes it, that person can save the document only by giving it a different file name.
On the Tools menu, click Options.
Click Security.
Select the Read-only recommended check box, and then click OK.
Click Save on the Standard toolbar.
Prevent users from accidentally changing a form
You can protect a form (form: A document that contains fill-in blanks, or form fields, in which you enter information. For example, you can create an online registration form in Microsoft Word that uses drop-down lists from which users can select entries.) when it is in progress and also protect the final version to prevent users from making changes as they fill it out. A form contains two types of content: form fields (form field: In a form, a location where a particular type of data, such as a name or address, is stored.), such as check boxes, and display content, such as text that labels a check box or instructions for filling out the form. People can use the form fields to fill out the form, but they should not be able to change the display content.
Protect a form to test how the final version will work
On the Forms toolbar (toolbar: A bar with buttons and options that you use to carry out commands. To display a toolbar, click Customize on the Tools menu, and then click the Toolbars tab.), click Protect Form .
Note If you want to reset form fields before you turn protection on for the form, click Reset Form Fields on the Forms toolbar.
Apply a password to prevent others from accidentally changing the form
Before you distribute a form that users will view and complete in Microsoft Word, you must protect it so that users can enter information only in the designated areas.
Note When you follow these steps, the form fields are reset to their default settings.
On the Tools menu, click Protect Document.
In the Protect Document task pane, under Editing restrictions, select the Allow only this type of editing in the document check box, and then click Filling in forms in the list of editing restrictions.
To protect only parts of a form from accidental changes, click Select sections, and then clear the check boxes of the sections (section: A portion of a document in which you set certain page formatting options. You create a new section when you want to change such properties as line numbering, number of columns, or headers and footers.) you don't want to protect.
Note To protect only parts of a form from accidental changes, those parts must be in separate sections (on the Insert menu, click Break to create section breaks).
Click Yes, Start Enforcing Protection.
To assign a password to the form so that others don't accidentally change the form's display content, type a password in the Enter new password (optional) box, and then confirm the password. Users who don't know the password can still enter information in the form fields.
Tip Users can check spelling and grammar in unprotected sections of a form. For example, in an employee review form, you might not protect a section designated for employee comments. Users can proof their text in that section before submitting the form.
Allow comments or tracked changes only
On the Tools menu, click Protect Document.
In the Protect Document task pane, select the Allow only this type of editing in the document check box.
Do one of the following:
Let reviewers change the document by inserting comments and tracked changes
In the list of editing restrictions, click Tracked changes.
Click Yes, Start Enforcing Protection.
Type a password in the Enter new password (optional) box, and then confirm the password.
Let reviewers insert comments only
In the list of editing restrictions, click Comments.
Click Yes, Start Enforcing Protection.
Do one of the following:
To assign a password to the document so that users who know the password can remove the protection, type a password in the Enter new password (optional) box, and then confirm the password.
To encrypt the document so that only authenticated owners of the document can remove the protection, click User authentication.
Protect formatting
On the Tools menu, click Protect Document.
In the Protect Document task pane, select the Limit formatting to a selection of styles check box.
Click Settings.
In the list of formatting styles in the Formatting Restrictions dialog box, select the check boxes for the styles you want to allow, and clear the check boxes for the styles you don't want to allow in the document.
TipTo limit formatting to the minimum number of recommended choices, click Recommended Minimum. You can restrict formatting to fewer choices, but doing so removes styles that Microsoft Word uses in certain features, such as tables of contents and bulleted or numbered lists.
Click Yes, Start Enforcing Protection.
Type a password in the Enter new password (optional) box, and then confirm the password.

Work like a expert with Excel shortcut and function keys

The following lists contain CTRL combination shortcut keys, function keys, and some other common shortcut keys, along with descriptions of their functionality. For more extensive reference information on all available shortcuts and their specific uses, see Keyboard shortcuts.
CTRL combination shortcut keys
Key Description
CTRL+ ( Unhides any hidden rows within the selection.

CTRL+) Unhides any hidden columns within the selection.

CTRL+& Applies the outline border to the selected cells.

CTRL+_ Removes the outline border from the selected cells.

CTRL+~ Applies the General number format.

CTRL+$ Applies the Currency format with two decimal places
(negative numbers in parentheses).

CTRL+% Applies the Percentage format with no decimal places.

CTRL+^ Applies the Exponential number format with two decimal places.

CTRL+# Applies the Date format with the day, month, and year.

CTRL+@ Applies the Time format with the hour and minute, and AM or PM.

CTRL+! Applies the Number format with two decimal places, thousands
separator, and minus sign (-) for negative values.

CTRL+- Displays the Delete dialog box to delete the selected cells.

CTRL+* Selects the current region around the active cell (the data area
by blank rows and blank columns). In a PivotTable, it selects the entire
PivotTable report.

CTRL+: Enters the current time.

CTRL+; Enters the current date.

CTRL+` Alternates between displaying cell values and displaying formulas in
the worksheet.

CTRL+' Copies a formula from the cell above the active cell into the cell or the
Formula Bar.

CTRL+" Copies the value from the cell above the active cell into the cell or the
Formula Bar.

CTRL++ Displays the Insert dialog box to insert blank cells.

CTRL+1 Displays the Format Cells dialog box.

CTRL+2 Applies or removes bold formatting.

CTRL+3 Applies or removes italic formatting.

CTRL+4 Applies or removes underlining.

CTRL+5 Applies or removes strikethrough.

CTRL+6 Alternates between hiding objects, displaying objects, and displaying
placeholders for objects.

CTRL+7 Displays or hides the Standard toolbar.

CTRL+8 Displays or hides the outline symbols.

CTRL+9 Hides the selected rows.

CTRL+0 Hides the selected columns.

CTRL+A Selects the entire worksheet. If the worksheet contains data,

CTRL+A If the worksheet contains data,selects the current region.

Pressing CTRL+A a second time selects the entire worksheet.
When the insertion point is to the right of a function name in a formula, displays the Function Arguments dialog box.

CTRL+SHIFT+A inserts the argument names and parentheses when the insertion point is to the right of a function name in a formula.

CTRL+B Applies or removes bold formatting.

CTRL+C Copies the selected cells.

CTRL+C followed by another CTRL+C displays the Microsoft Office Clipboard.

CTRL+D Uses the Fill Down command to copy the contents and format of the topmost cell of a selected range into the cells below.

CTRL+F Displays the Find dialog box.

SHIFT+F5 also displays this dialog box, while SHIFT+F4 repeats the last Find action.

CTRL+G Displays the Go To dialog box. F5 also displays this dialog box.

CTRL+H Displays the Find and Replace dialog box.

CTRL+I Applies or removes italic formatting.

CTRL+K Displays the Insert Hyperlink dialog box for new hyperlinks or the Edit Hyperlink dialog box for selected existing hyperlinks.

CTRL+L Displays the Create List dialog box.

CTRL+N Creates a new, blank file.

CTRL+O Displays the Open dialog box to open or find a file.

CTRL+SHIFT+O selects all cells that contain comments.

CTRL+P Displays the Print dialog box.

CTRL+R Uses the Fill Right command to copy the contents and format of the leftmost cell of a selected range into the cells to the right.

CTRL+S Saves the active file with its current file name, location, and file format.

CTRL+U Applies or removes underlining.

CTRL+V Inserts the contents of the Clipboard at the insertion point and replaces any selection. Available only after you cut or copied an object, text, or cell contents.

CTRL+W Closes the selected workbook window.

CTRL+X Cuts the selected cells.

CTRL+Y Repeats the last command or action, if possible.

CTRL+Z Uses the Undo command to reverse the last command or to delete the last entry you typed.

CTRL+SHIFT+Z uses the Undo or Redo command to reverse or restore the last automatic correction when AutoCorrect Smart Tags are displayed.
Function keys
Key Description
F1
Displays the Help task pane.
CTRL+F1 closes and reopens the current task pane.
ALT+F1 creates a chart of the data in the current range.
ALT+SHIFT+F1 inserts a new worksheet.
F2
Edits the active cell and positions the insertion point at the end of the cell contents. It also moves the insertion point into the Formula Bar when editing in a cell is turned off.
SHIFT+F2 edits a cell comment.
F3
Pastes a defined name into a formula.
SHIFT+F3 displays the Insert Function dialog box.
F4
Repeats the last command or action, if possible.
CTRL+F4 closes the selected workbook window.
F5
Displays the Go To dialog box.
CTRL+F5 restores the window size of the selected workbook window.
F6
Switches to the next pane in a worksheet that has been split (Window menu, Split command).
SHIFT+F6 switches to the previous pane in a worksheet that has been split.
CTRL+F6 switches to the next workbook window when more than one workbook window is open.
Note When the task pane is visible, F6 and SHIFT+F6 include that pane when switching between panes.
F7
Displays the Spelling dialog box to check spelling in the active worksheet or selected range.
CTRL+F7 performs the Move command on the workbook window when it is not maximized. Use the arrow keys to move the window, and when finished press ESC.
F8
Turns extend mode on or off. In extend mode, EXT appears in the status line, and the arrow keys extend the selection.
SHIFT+F8 enables you to add a non-adjacent cell or range to a selection of cells by using the arrow keys.
CTRL+F8 performs the Size command (on the Control menu for the workbook window) when a workbook is not maximized.
ALT+F8 displays the Macro dialog box to run, edit, or delete a macro.
F9
Calculates all worksheets in all open workbooks.
F9 followed by ENTER (or followed by CTRL+SHIFT+ENTER for array formulas) calculates the selected a portion of a formula and replaces the selected portion with the calculated value.
SHIFT+F9 calculates the active worksheet.
CTRL+ALT+F9 calculates all worksheets in all open workbooks, regardless of whether they have changed since the last calculation.
CTRL+ALT+SHIFT+F9 rechecks dependent formulas, and then calculates all cells in all open workbooks, including cells not marked as needing to be calculated.
CTRL+F9 minimizes a workbook window to an icon.
F10
Selects the menu bar or closes an open menu and submenu at the same time.
SHIFT+F10 displays the shortcut menu for a selected item.
ALT+SHIFT+F10 displays the menu or message for a smart tag. If more than one smart tag is present, it switches to the next smart tag and displays its menu or message.
CTRL+F10 maximizes or restores the selected workbook window.
F11
Creates a chart of the data in the current range.
SHIFT+F11 inserts a new worksheet.
ALT+F11 opens the Visual Basic Editor, in which you can create a macro by using Visual Basic for Applications (VBA).
ALT+SHIFT+F11 opens the Microsoft Script Editor, where you can add text, edit HTML tags, and modify any script code.
F12
Displays the Save As dialog box.
Other useful shortcut keys
Key
Description
ARROW KEYS
Move one cell up, down, left, or right in a worksheet.
CTRL+ARROW KEY moves to the edge of the current data region (data region: A range of cells that contains data and that is bounded by empty cells or datasheet borders.) in a worksheet.
SHIFT+ARROW KEY extends the selection of cells by one cell.
CTRL+SHIFT+ARROW KEY extends the selection of cells to the last nonblank cell in the same column or row as the active cell.
LEFT ARROW or RIGHT ARROW selects the menu to the left or right when a menu is visible. When a submenu is open, these arrow keys switch between the main menu and the submenu.
DOWN ARROW or UP ARROW selects the next or previous command when a menu or submenu is open.
In a dialog box, arrow keys move between options in an open drop-down list, or between options in a group of options.
ALT+DOWN ARROW opens a selected drop-down list.
BACKSPACE
Deletes one character to the left in the Formula Bar.
Also clears the content of the active cell.
DELETE
Removes the cell contents (data and formulas) from selected cells without affecting cell formats or comments.
In cell editing mode, it deletes the character to the right of the insertion point.
END
Moves to the cell in the lower-right corner of the window when SCROLL LOCK is turned on.
Also selects the last command on the menu when a menu or submenu is visible.
CTRL+END moves to the last cell on a worksheet, in the lowest used row of the rightmost used column.
CTRL+SHIFT+END extends the selection of cells to the last used cell on the worksheet (lower-right corner).
ENTER
Completes a cell entry from the cell or the Formula Bar, and selects the cell below (by default).
In a data form, it moves to the first field in the next record.
Opens a selected menu (press F10 to activate the menu bar) or performs the action for a selected command.
In a dialog box, it performs the action for the default command button in the dialog box (the button with the bold outline, often the OK button).
ALT+ENTER starts a new line in the same cell.
CTRL+ENTER fills the selected cell range with the current entry.
SHIFT+ENTER completes a cell entry and selects the cell above.
ESC
Cancels an entry in the cell or Formula Bar.
It also closes an open menu or submenu, dialog box, or message window.
HOME
Moves to the beginning of a row in a worksheet.
Moves to the cell in the upper-left corner of the window when SCROLL LOCK is turned on.
Selects the first command on the menu when a menu or submenu is visible.
CTRL+HOME moves to the beginning of a worksheet.
CTRL+SHIFT+HOME extends the selection of cells to the beginning of the worksheet.
PAGE DOWN
Moves one screen down in a worksheet.
ALT+PAGE DOWN moves one screen to the right in a worksheet.
CTRL+PAGE DOWN moves to the next sheet in a workbook.
CTRL+SHIFT+PAGE DOWN selects the current and next sheet in a workbook.
PAGE UP
Moves one screen up in a worksheet.
ALT+PAGE UP moves one screen to the left in a worksheet.
CTRL+PAGE UP moves to the previous sheet in a workbook.
CTRL+SHIFT+PAGE UP selects the current and previous sheet in a workbook.
SPACEBAR
In a dialog box, performs the action for the selected button, or selects or clears a check box.
CTRL+SPACEBAR selects an entire column in a worksheet.
SHIFT+SPACEBAR selects an entire row in a worksheet.
CTRL+SHIFT+SPACEBAR selects the entire worksheet.
If the worksheet contains data, CTRL+SHIFT+SPACEBAR selects the current region. Pressing CTRL+SHIFT+SPACEBAR a second time selects the entire worksheet.
When an object is selected, CTRL+SHIFT+SPACEBAR selects all objects on a worksheet.
ALT+SPACEBAR displays the Control menu for the Excel window.
TAB
Moves one cell to the right in a worksheet.
Moves between unlocked cells in a protected worksheet.
Moves to the next option or option group in a dialog box.
SHIFT+TAB moves to the previous cell in a worksheet or the previous option in a dialog box.
CTRL+TAB switches to the next tab in dialog box.
CTRL+SHIFT+TAB switches to the previous tab in a dialog box.

Ms Word 2003 Logo Screen

Ms Word 2003 Startup screen.

Ms Excel 2003 Logo Screen

Microsoft Excel startup screen.

Believe it or not : Excel Dominating the Globe

We at My Office power just posting about the scope of Ms Excel and Ms Word and all other Ms office applications. We have just began to let you know how important is it to be aware of market demands today. Perhaps Excel has taken place in major IT industries providing international software soloutions. Oracle the name is enough we need not to elaborate about this name. Oracle is now has launched software applications in Ms Excel globally. And as we have been speaking about Excel Dominance in the global industry since its inception day by day we are updating about the hottest and latest on Excel and all other Ms Office applications. My blog is not just upto posting it is something more. You send your comments on our blog we will explore our knowledge for you. As always your truly , yours own, myofficepower.blogspot.

Efforts to bring you source from world wide webs

we at my officer power blog a unique resources blog for Ms Office application is working for a station of resources on this blog. You too can contribute in this efforts. Provide your best ideas to improve this blog with the latest and oldest web resources on Ms Office applications. Lets make it a ocean of information on the web.This blogs blogger loves google!!

Make google your own

Take control of Microsoft Word through event

Word 2002 Technical Articles
Take Control of Microsoft Word Through Events

Bill CoanMicrosoft Word MVP
May 2003
Applies to: Microsoft® Word 2000 and later versions
Summary: Bill Coan, a Microsoft Word Most Valuable Professional (MVP), provides information about how to change the way Word works. Application event procedures are the most powerful and flexible way to do this but other methods are useful, too, so he starts with the easier methods and works his way up to application event procedures. (13 printed pages)
Contents
IntroductionReplace Built-in RoutinesTake Advantage of "Auto" MacrosCreate "Document Event" ProceduresDiscover the Power of "Application Event" ProceduresTest Your Event HandlerShorter Names for Your Event Handler and Application ObjectsApplication Events Supported By Word 2002 and LaterUseful Examples of Application Event ProceduresAbout the Author
Introduction
The single smartest thing the Microsoft® Word development team ever did was to acknowledge and accept its own limitations. (We should all be so humble.)
Rather than viewing itself as an all-knowing, all-seeing, all-controlling gang of software dictators, the development team recognized from the beginning that power users and independent developers would have their own ideas about how Word should behave. That's why, with each new release of Word, the team has provided new, more exciting ways for power users and independent developers to alter Word's behavior.
In this article, we'll start by reviewing briefly some of the oldest and easiest-to-use techniques for altering Word's behavior. Then we'll move on and examine some of the newest and most exciting techniques for taking control of our favorite word processing application.
Replace Built-in Routines
One way we can alter Word's behavior is by creating macros to run in place of Word's built-in routines. For example, Word has a built-in routine called FilePrint that runs when a user chooses the File menu and then selects Print. If we create a macro called FilePrint, Word runs our macro instead of the built-in routine. (To see a list of built-in routines that can be overridden with like-named macros, on the Tools menu, point to Macro, and then click Macros. On the Macros dialog box set the Macros in: list to Word commands.)
Take Advantage of "Auto" Macros
Another way we can alter Word's behavior is by creating "auto" macros that run automatically when a user creates a new document (or opens or closes an existing one) based on a particular template. In addition, we can create auto macros that run automatically when Word loads or unloads a global template. The following table lists the auto macros supported by Word and describes when Word runs each one.
Auto Macro
Runs when …
AutoNew
Runs, if present, when a user creates a new document from the template containing the macro. (Note Technically, this is a legacy capability that, while still supported and likely to be supported well into the future, has since been supplanted by the Document_New event discussed later in this article.)
AutoOpen
Runs, if present, when a user opens an existing document based on the template containing the macro. (Note This is a legacy capability that, while still supported and likely to be supported well into the future, has since been supplanted by the Document_Open event discussed later in this article.)
AutoClose
Runs, if present, when a user closes an existing document based on the template containing the macro. (Note This is a legacy capability that, while still supported and likely to be supported well into the future, has since been supplanted by the Document_Close event discussed later in this article.)
AutoExec
Runs, if present, when the template containing the macro is loaded globally. (Note Normal.dot is loaded globally when Word starts. Templates stored in Word's Startup folder or the Office Startup folder also are loaded globally when Word starts. In addition, a template can be loaded globally by clicking the Tools menu, clicking Templates and Add-Ins, and then clicking Add or selecting a template in the list of Global templates and add-ins.)
AutoExit
Runs, if present, when the template containing the macro has been globally loaded and is then unloaded. (All globally loaded templates are unloaded when Word exits. In addition, a globally loaded template can be unloaded by clicking the Tools menu, clicking Templates and Add-Ins, and then clearing the template checkbox in the list of Global templates and add-ins.)
Create "Document Event" Procedures
Starting with Word 97, the distinction between Word documents and Word templates was blurred a bit when documents were given the ability to store Visual Basic for Applications (VBA) code projects. The most important aspect of this change is that both documents and templates were given the ability to store "document event" procedures, for example, procedures that run automatically when an event takes place that affects a particular document. The following table lists the document event procedures supported by Word since Word 97 and describes when Word runs each one.
Document Event Procedure
Runs when …
Document_New
Runs, if present, when a user creates a new document from a template containing the procedure. (Does NOT run when a user creates a new document from an existing document. Therefore, it doesn't make sense to store a Document_New procedure in a document's VBA code project. Instead, the procedure should always be stored in a template's VBA code project.)
Document_Open
Runs, if present, when a user opens a document containing the procedure or opens a document attached to the template containing the procedure. (Note If a document contains a Document_Open procedure and the template attached to the document also contains a Document_Open procedure, Word will run both procedures, one after the other. The procedure stored in the template runs first, followed immediately by the procedure stored in the document.)
Document_Close
Runs, if present, when a user closes a document containing the procedure or closes a document attached to the template containing the procedure. (Note If a document contains a Document_Close procedure and the template attached to the document also contains a Document_Close procedure, Word will run both procedures, one after the other. The procedure stored in the template runs first, followed immediately by the procedure stored in the document.)
Note When a user creates a new document, or opens or closes an existing one, Word first checks to see whether the template attached to the document contains a procedure for that event. If it does, then Word runs the procedure. Next, Word checks to see whether the document itself contains a procedure for the event. If it does, then Word runs that procedure. (If the template and the document both contain a procedure for the event, Word runs both procedures, one after the other. If neither the template nor the document contains a procedure, Word carries out the user's action without running a procedure.)
Important One benefit of document event procedures, as compared to auto macros, is that document event procedures stored in templates can coexist with those stored in documents. That is, if a document and its attached template both contain a procedure for a particular document event, Word will run both procedures, starting with the one stored in the template. This isn't true of auto macros. If a document contains an AutoOpen macro and its attached template also contains an AutoOpen macro, Word will run only the one stored in the document.
How to Store Document Event Procedures in a VBA Project
No special preparations are needed to store a document event procedure in a VBA code project. On the contrary, every VBA code project, whether it belongs to a template or to a document, by default contains a special module (called ThisDocument) specifically designed for storing document event procedures. Here's how to store a document event procedure in such a module:
Start Word and open the document or template in which you want the procedure to be stored. (If the procedure is to be stored in a template, you can create or open a document based on the template, if preferred, rather than opening the template itself.)
Press Alt+F11 to launch the Visual Basic Editor.
In the Project Explorer pane (upper left corner of the screen), locate the VBA project for your document or template.
Note For each document open in Word, you will find a project for that document and also a project for the document's attached template. Make sure you choose the project where you want the event procedure to be stored.
If you see a plus sign (+) next to the project, click it to expand the project tree. This will reveal that the project contains a branch for Microsoft Word Objects. If you see a plus sign next to this branch, click it to expand the branch. This will reveal the project's ThisDocument module.
Double-click the project's ThisDocument module to display the contents of the module in the Code pane (right side of the screen).
At the top of the Code pane, click the Object drop-down list and select Document. Then in the Procedure drop-down list, click Close, then click New, and finally click Open. This will create an empty procedure for the Document_Close, Document_New, and Document_Open events. Type the code in each procedure that you want to run when that event occurs. For example, you could type the following, substituting the appropriate event name, which displays a dialog box telling you what event has fired:
Copy CodeMsgbox "The has just occurred."
On the File menu, click Save and then click Close and return to Microsoft Word.
Discover the Power of "Application Event" Procedures
In addition to introducing document event procedures, Word 97 introduced application event procedures—another new and exciting way for power users and developers to alter Word's behavior.
Like document event procedures, application event procedures run automatically when certain events occur. To that extent, application event procedures are as easy to understand as document event procedures.
When you look more deeply into application event procedures, you discover that they are a "good news"/"bad news"/"more good news" proposition. The good news is that they provide far more power and flexibility than document event procedures. The bad news is that a certain amount of preparation is required before a VBA code project can take advantage of them. The final good news is this: the amount of preparation needed is very small relative to the gain in power and flexibility.
Note Back when Word 97 was introduced, Word supported only two application events, so you didn't have much to lose if you decided not to investigate them. With each new version of Word since then, the number of application events supported by Word has steadily increased. For example, Word 2002 SP-2 supports 23 different application events. It's fair to assume that Word 2003 will support an even greater number of application events. So if you haven't explored application event procedures before now, you couldn't pick a better time to begin.
Before examining application event procedures in detail, it's helpful to back up a moment and consider a question inherent in our earlier discussion of document event procedures: "Why aren't any special preparations needed when storing a document event procedure in a VBA code project?"
One reason for this is that Word already knows where document event procedures can be found (if present). As noted earlier, by design, such procedures can be found in the ThisDocument module of the VBA code project for the document or its attached template.
Another reason no special preparations are needed for document event procedures is that every time a user creates a new document, opens an existing document, or closes a document, Word automatically checks to see whether a corresponding event procedure is present. No one has to tell Word to do this.
Apparently the Word development team felt that users wouldn't notice or else wouldn't be troubled by the very slight delay caused by always checking for the presence of document event procedures. This makes sense, since the delay is negligible compared to the disk- or network-access delays when a user creates, opens, or closes a document.
Neither of the above conditions applies to application event procedures. To start with, no default location has been established for such procedures, so Word doesn't know where to check for them until you tell it where to check.
Moreover, application events occur very frequently and at times when users are accustomed to very rapid responses. Therefore, it doesn't make sense for Word to check for event procedures every time those events occur, unless there's reason to believe that such procedures are present. To solve this problem, Word checks for application event procedures only when you explicitly tell it to.
So how do you tell Word where you've stored your application event procedures and that you want it to check for them whenever an application event occurs? The answer is very simple in concept and almost as simple in practice. In concept, all you have to do is the following:
Create an "event handler" class module with event procedures stored inside it.
Note A class module is said to describe a category or a "class" of objects. Your class module will describe a class of objects known as event handlers. Later you will create an object that belongs to this class. (Technically, you could create two or three or even more such objects but one is probably all you'll need.) The only thing a class module does is describe what each member of a class will be like. It's almost as if you're creating a mold for event handlers so that, later on, you can create as many event handlers as you need.
Create an event handler object based on the description in your event handler class module.
Note An object is sometimes referred to as a member or an "instance" of a class. Multiple instances of a class can be created, if desired, and each one will conform to the description stored in the class module for that class.
If this all seems rather mysterious, don't worry. More than likely, it's only because some of the terminology may be new to you. In the paragraphs that follow, we'll put these concepts into practice and along the way we'll stop and review what's going on.
Important Some of the names used below are ridiculously long but I hope they will help you visualize how application events are handled. Later I will suggest some shorter names but for now please bear with me and accept the names suggested.
How to Store Application Event Procedures in a VBA Project
Application event procedures can be stored in a VBA code project for a document, a regular template, or a global template. Of these locations, a global template is the most commonly used location because application events are themselves global. That is, they affect all documents. Therefore, in the steps that follow, we'll assume that you want to store your application event procedures in an add-in template called EventHandlerAddin.dot. Here's what to do:
Start Word and create a new template and immediately save it as EventHandlerAddin.dot.
Press Alt+F11 to launch the Visual Basic Editor.
In the Project Explorer pane (upper left corner of the screen), locate the VBA project for EventHandlerAddin.dot.
Note For each document open in Word, you will find a project for that document and also a project for the document's attached template. Make sure you choose the project for EventHandlerAddind.dot.
Right-click the project, click the Insert menu, and then click Class Module. In the Properties pane (lower left corner of screen) click in the Name field and set the class module's name to clsEventHandler.
In the Code pane (right side of screen) type the following:
Copy Code...
'Declare that only an instance of Word can be assigned to this variable
'and also that the assigned instance should be notified to
'check inside the event handler for application event procedures.
Public WithEvents _
AppThatLooksInsideThisEventHandler _
As Word.Application
...
At the top of the Code pane, click the Object drop-down list, and select AppThatLooksInsideThisEventHandler. In the Procedure drop-down list, click DocumentBeforeClose, then click DocumentBeforePrint,and finally click DocumentBeforeSave. This will create an empty procedure for each of these events. We will explore other events later.
Type the code that you want to run when that event occurs into each procedure. In this case, let's enter a simple message box that will display the name of the associated application event when the procedure runs. For example, the first statements shown below applies to the DocumentBeforeClose event procedure, the second set apply to the DocumentBeforePrint, and the third to the DocumentBeforeSave event procedure:
Copy CodePrivate Sub AppThatLooksInsideThisEventHandler_DocumentBeforeClose(ByVal Doc As Document, Cancel As Boolean)
MsgBox "Event: DocumentBeforeClose"
End Sub
Private Sub AppThatLooksInsideThisEventHandler_DocumentBeforePrint(ByVal Doc As Document, Cancel As Boolean)
MsgBox "Event: DocumentBeforePrint"
End Sub
Private Sub AppThatLooksInsideThisEventHandler_DocumentBeforeSave(ByVal Doc As Document, SaveAsUI As Boolean, Cancel As Boolean)
MsgBox "Event: DocumentBeforeSave"
End Sub
On the File menu, choose Save.
Let's pause and review what we've accomplished so far.
We've created a class module called clsEventHandler that describes a class of event handler objects but doesn't bring such an object into existence (also known as instantiating the object). An event handler object will be brought into existence later. All that exists in the class module is a description of what each event handler will be like.
When created, an event handler object will include a Word application object with events and also will include procedures for the following application events: DocumentBeforeClose, DocumentBeforePrint, and DocumentBeforeSave.
Note In this context, "a Word application object" means a data structure in memory reflecting all the properties and methods of the Word application and "with events" means that the instance of Word involved will be notified that it needs to check for event procedures inside the event handler object whenever an application event occurs.
To emphasize: So far, all we've done is define an event handler object. No such object has been created yet. We're almost there, so let's proceed:
Right-click your code project, click the Insert menu, and then click Module. In the Properties pane (lower left corner of screen) click in the Name field and type modHandleEvents.
In the Code pane (right side of screen) type the following:
Copy Code...
' declare type of object to be stored in the objEventHandler variable
Dim objEventHandler As clsEventHandler
Sub CreateEventHandler()
'create a new event handler object and assign it to objEventHandler
Set objEventHandler = New clsEventHandler
'Notify the current instance of Word to check for
'application event procedures
'inside the event handler object
Set objEventHandler.AppThatLooksInsideThisEventHandler = Word.Application
End Sub
Sub DestroyEventHandler()
'release the memory being used by the event handler object
Set objEventHandler = Nothing
End Sub
Sub AutoExec()
'whenever this template is loaded globally,
'automatically create an event handler
CreateEventHandler
End Sub
Sub AutoExit()
'whenever this template is unloaded,
'automatically destroy the event handler
DestroyEventHandler
End Sub
On the File menu, click Save, then click Close and return to Microsoft Word.
Close Word.
Let's pause again and review what we've accomplished.
We've created a code module called modHandleEvents and in it, we've declared that we will be working with a variable called objEventHandler of type clsEventHandler. This declaration doesn't create an object, it just sets its type. That is, it tells the compiler what kind of object the variable refers to so that the compiler (and Microsoft IntelliSense® feature) can help us use the variable in accordance with the object description stored in clsEventHandler.
We've established a subroutine called CreateEventHandler. This subroutine creates a new instance of the class called clsEventHandler and assigns it to objEventHandler. In addition, this subroutine assigns the current instance of Word to the AppThatLooksInsideThisEventHandler property of objEventHandler.
We've also established a subroutine called DestroyEventHandler. This subroutine destroys our event handler by releasing the memory allocated to objEventHandler.
Finally, we've created an AutoExec macro that will run automatically when this template is loaded globally and an AutoExit macro that will run automatically when this template is unloaded. The AutoExec macro automatically creates an event handler. The AutoExit macro automatically destroys the event handler.
At last our event handler exists! Or at least, it will exist as soon as Word loads our template globally and runs the CreateEventHandler subroutine.
Another thing that will happen when Word runs the CreateEventHandler subroutine is that the current instance of Word will be assigned to our event handler's AppThatLooksInsideThisEventHandler property. As a result, Word will be notified to check for event procedures inside the event handler whenever an application event occurs.
In the case of certain events (DocumentBeforeClose, DocumentBeforePrint, and DocumentBeforeSave), Word will find an associated event procedure and run it. In the case of other events, Word will look for but not find an associated event procedure and therefore will complete its normal actions without running a procedure.
Test Your Event Handler
Testing your event handler will take just a few seconds. To see it in action, proceed as follows:
Start Word.
On the Tools menu, click Templates and Add-ins, click Add, click EventHandlerAddin.dot, and then click OK. This will cause Word to load the add-in template globally which will cause Word to run the add-in's AutoExec macro, which in turn will create an event handler object in memory. (It's a long chain of events, isn't it, but now that you understand that chain, it needn't seem strange or intimidating.)
Try saving, printing, and closing some documents. Each time you do this, a message will pop up, indicating that an application event has occurred and that Word has responded by running one of your application event procedures.
Click the Tools menu, click Templates and Add-ins, clear the EventHandlerAddin.dot checkbox, and then click OK. This will cause Word to unload the add-in template which will cause Word to run the add-in's AutoExit macro, which in turn will destroy the event handler object. (It's another long chain of events, but a familiar one by now.)
Try saving, printing, and closing some documents. When you do this, no messages will pop up because Word is no longer checking for application event procedures and in any case your application event procedures are no longer present in memory.
Shorter Names for Your Event Handler and Application Objects
In this article, I've suggested that you create a class module called clsEventHandler and that within this class module you declare a Word application object variable called AppThatLooksInsideThisEventHandler.
I suggested these names to help you visualize what goes on when you create an event handler object and assign an instance of Word to it. I am the first to admit, however, that the clarity of a name is in the eye of the beholder.
For my own projects, I'm perfectly happy using a class module called clsEventHandler. On some occasions, I change the name to clsAppEventHandler, to help me remember that my event handler is designed to handle application events only. Sometimes I leave off the cls prefix, calling the class module simply AppEventHandler.
As for the Word application object variable inside the class module, my preferred name for it is EventSource. This works out very well with VBA's IntelliSense feature, because later, in the regular code module (modHandleEvents) where I create an event handler object, I can simply type a period and the IntelliSense drop-down list help me choose an EventSource property for the event handler. This results in the following code:
Copy CodeDim objEventHandler As clsEventHandler
Sub CreateEventHandler()
Set objEventHandler = New clsEventHandler
Set objEventHandler.EventSource = Word.Application
End Sub
As you continue experimenting with application event procedures, you'll likely want to experiment until you come up with names that suit you and help you visualize what's going on.
Application Events Supported By Word 2002 and Later
As noted above, each new version of Word has supported a greater number of application events than the versions that preceded it. The following list is current for Microsoft Office 2002 Service Pack 2. To learn which application events are supported by your version of Word, look up application events in VBA Help.
Application Event Procedure
Runs when …
DocumentBeforeClose
Immediately before any open document closes.
DocumentBeforePrint
Before any open document is printed.
DocumentBeforeSave
Before any open document is saved.
DocumentChange
A new document is created, when an existing document is opened, or when another document is made the active document.
DocumentOpen
A document is opened.
EPostageInsert
A user inserts electronic postage into a document.
EPostagePropertyDialog
A user clicks the E-postage Properties (Labels and Envelopes dialog box) button or Print Electronic Postage toolbar button. This event allows a third-party software application to intercept and show their properties dialog box.
MailMergeAfterMerge
After all records in a mail merge have merged successfully.
MailMergeAfterRecordMerge
After each record in the data source successfully merges in a mail merge.
MailMergeBeforeMerge
A merge is executed before any records merge.
MailMergeBeforeRecordMerge
As a merge is executed for the individual records in a merge.
MailMergeDataSourceLoad
The data source is loaded for a mail merge.
MailMergeDataSourceValidate
A user performs address verification by clicking Validate in the Mail Merge Recipients dialog box.
MailMergeWizardSendToCustom
The custom button is clicked on step six of the Mail Merge Wizard.
MailMergeWizardStateChange
A user changes from a specified step to a specified step in the Mail Merge Wizard.
NewDocument
A new document is created.
Quit
The user quits Word.
WindowActivate
Any document window is activated.
WindowBeforeDoubleClick
The editing area of a document window is double-clicked, before the default double-click action.
WindowBeforeRightClick
The editing area of a document window is right-clicked, before the default right-click action.
WindowDeactivate
Any document window is deactivated.
WindowSelectionChange
The selection changes in the active document window.
WindowSize
The application window is resized or moved.
Useful Examples of Application Event Procedures
The code presented in this article isn't really of much use to anyone except for learning how to set up application event procedures in Word. Some interesting and useful examples of application event procedures created by me and my fellow Word MVPs can be found at the following URLs:
How can I prevent users from editing the header of a document in Word 2000 or higher?
Writing application event procedures
How to create global event procedures similar to AutoOpen, AutoNew and AutoClose, without using Normal.dot
Running a macro automatically when Word starts or quits
Intercepting events like Save and Print

My Office Power: Excel plays a major role in IT industries

My Office Power: Excel plays a major role in IT industries

Excel plays a major role in IT industries

Big IT firms in India like Wipro has implemented Excel for e-procurement business providing e-tendering services to its clients from governmental organisations.

Know about security of your files

You must be keeping important data in your excel sheets may be it is about financial, official statistics data or whatever it may be very confidential, you never know if some one get access to it and got stolen from your system, then what will you do ?

You should keep it securely in your system by means of protecting your document feature of Ms Office.

If you don't know about this feature of Ms Office learn about this today...........


If you want to protect a Excel file protect it by applying password to the particular file,
follow the link below to know how you can safegaurd your documents.

LEARN HOW TO PROTECT YOUR DOCUMENTS

Shortcut Keys in Word 2007 (Excel 2007 & PowerPoint 2007)

So you are a hotshot who doesn’t need to use a mouse! Fair enough, power users tend to find they can do tasks quicker by using shortcut keys. Shortcut keys are combinations of keystrokes on your keyboard that can make the program do a certain task.
The new Ribbon UI in Word 2007, Excel 2007, and PowerPoint 2007 is easier to use with a mouse, but if you want to use your keyboard shortcuts, there is a quick, easy, and visual way to find out what you need to press.
All you need to do, is hit the “Alt” key। Simple as that. By pressing the “Alt” button in Word 2007, the keyboard shortcuts appear on top of all the different sections of the Ribbon.

For example, (looking at the screenshot), to open the file menu, all I need to do is hit “ALT+F”. If I want to save my file, which happens to be one of the Quick Access Toolbar buttons, I could hit “Alt+1″. To change to the Insert Tab in the Word 2007 ribbon, I could hit “Alt+N”
As soon as you go to another tab in the ribbon, if you hit “Alt” again, you can see all the shortcuts for each piece of functionality on that tab.

Please your comments for this for sure...

Now the wait is over

To get accesss to Ms Access just follow the link

click here to get answers to all your queries ..

Something HOT to Arrive Ms Access

To find out what we gonna bring for you on hot Ms Acces issue
keep on visiting this blog for frequent hours and you fill find something
useful......

Cool Power Point Template just for you !!

These PowerPoint template kits are for your use only! They can be used for any presentation your are creating, for yourself or for a client। They may not be distributed, sold, or displayed on the Web by anyone except soniacoleman।

please visit http://www.soniacoleman.com/ for beautiful power point templates.

Do you know? even if you dont have Ms word installed on your computer, you can view your word documents

Word Viewer 2003

Get it right now and enjoy !!

View, print and copy Word documents, even if you don't have Word installed. This download is a replacement for Word 97 Viewer and all previous Word Viewer versions.

Overview
Word Viewer 2003 lets you open Word 2003 documents and documents created with all previous versions of Microsoft Word for Windows® and Microsoft Word for Macintosh. In addition to Word document files (.doc), you can also open files saved in the following formats:

* Rich Text Format (.rtf)
* Text (.txt)
* Web Page formats (.htm, .html, .mht, .mhtml)
* WordPerfect 5.x (.wpd)
* WordPerfect 6.x (.doc, .wpd)
* Works 6.0 (.wps)
* Works 7.0 (.wps)
* XML (.xml)

With Word Viewer 2003, you can view, print, and copy document contents to another program. However, you cannot edit an open document, save a document, or create a new document. This download is a replacement for Word 97 Viewer and all previous Word Viewer versions.

NOTE: So long as you comply with the other license terms for the Microsoft Office Word 2003 Viewer, you may distribute such viewer without a document created by Microsoft Office.
click the link below to download..
DOWNLOAD IT NOW

The above information is taken from Microsoft Website.

Features of Word Processing

Most Word Processor available today allows more than just creating and editing documents. They have wide range of other tools and functions, which are used in formatting the documents. The following are the main features of a Word Processor

Text is typing into the computer, which allows alterations to be made easily.
Words and sentences can be inserted, amended or deleted.
Paragraphs or text can be copied /moved throughout the document.
Margins and page length can be adjusted as desired.
Spelling can be checked and modified through the spell check facility.
Multiple document/files can be merged.
Multiple copies of letters can be generated with different addresses through the mail-merge facility

Official Google Webmaster Central Blog: Discover your links

Official Google Webmaster Central Blog: Discover your links

See how Excel can reduce your mental stress

Microsoft Excel (full name Microsoft Office Excel) is a spreadsheet program written and distributed by Microsoft for computers using the Microsoft Windows operating system and for Apple Macintosh computers. It features an intuitive interface and capable calculation and graphing tools which, along with aggressive marketing, have made Excel one of the most popular microcomputer applications to date. It is overwhelmingly the dominant spreadsheet application available for these platforms and has been so since version 5 in 1993 and its bundling as part of Microsoft Office.

Yes Excel has got the power to reduce your mental stress by easing your complex calculaions.

Why Excel is so powerful because Excel is a software where a spreadsheet is a rectangular table (or grid) of information, often financial information. The word came from "spread" in its sense of a newspaper or magazine item (text and/or graphics) that covers two facing pages, extending across the center fold and treating the two pages as one large one. The compound word "spread-sheet" came to mean the format used to present bookkeeping ledgers — with columns for categories of expenditures across the top, invoices listed down the left margin, and the amount of each payment in the cell where its row and column intersect—which were traditionally a "spread" across facing pages of a bound ledger (book for keeping accounting records) or on oversized sheets of paper ruled into rows and columns in that format and approximately twice as wide as ordinary paper.

more.....