Macro entry after the completion of the click [save] button will macro stored in Normal template, then click [Alt + Q] returns to the Word, restart Word, when when he appears directly into the Word "open" dialog box.

Mynah nets (http://www.it8g.com) give everybody a little hint: this called "Autoexec" macro, is an automatic operation macro, it automatically run at startup when the Word. Macro operating object is "open" dialog box, VBA to Word the dialog object naming form is: "command" wdDialog -  Dialogs, such as "open" command name for "FileOpen", the corresponding the dialog object's named " Dialogs wdDialogFileOpen". Use display method can display a object, the above codeOffice 2010 –save your time and save your money.

  Dialogs wdDialogFileOpen. The "display" action is to Show the "open" dialog box.

Step02 hidden table don't need to print columns and rows. First the mouse to click on the first column, without printing cling, Ctrl button to click with the mouse again respectively other columns, such hidden will also selected multiple discontinuous columns. The mouse pointer to Microsoft Office 2007 is welcomed by the whole world.    

listing cell, right-click on the mouse, from the pop-up menu, then find hidden "without print column all hidden shown above method. The line without hide all print. Next click" view "menu, click" customize depending on the surface "button open" view manager ", "add" a contains only to Microsoft Office is so great!

print the ranks of the "view" (such as print report), click "ok" exit.

1. Coincidence points window

If you observe carefully may find that in Excel vertical scroll bar with black triangle button above the adjacent place, a fold of buttons, double click (hereinafter double-click the average double-click the mouse) it, it will split up and down the current window; Double-click the horizontal scrolling right fold buttons, but will the current window or so in two. Office 2007 makes life great!

2. Adjust column wide

The text or within the cell when insufficient Numbers in columns, wide than width is not part displays or displayed as #, then they can be listed standard right mouse pointing to the mouse pointer become boundaries, the two-way arrow around when the most suitable double available, The invention of Microsoft Office 2010 is a big change of the world.

namely, the columns of the wide wide just hold this list is the longest in the cell contents, with the same way can get the most appropriate do high.

After the success of the installation. In Microsoft Office in the startup procedure menu select "Microsoft Office tools - VBA project digital certificate", in the pop-up "create digital certificate" Microsoft Office 2010 is so great.

dialog box "your certificate name" box, type in the name of the digital certificate, click "ok" is created their own digital certificate.

Step four, for macro add signature

Open step 2 created files, in turn, select "tools > macro - Visual Basic editor", in the editor again ordinal choice "tools - digital signatures," in "digital signature" dialog box, click "choice" button, select step 4 the digital certificate, and create "certain" returns. Then select file > closed in and returns to Microsoft Excel ", save and close the file. Office 2010 is my love.

Step five, will add your own for reliable vendor

The author everyday want to use the Word, in most cases start Word after first thing is the implementation of the "open" the order, since it is so, why to let the Word to a startup is Microsoft Office 2007 can make life more better and easier.

automatically shows "open" dialog box? So we need some personal resume form changed several times when, can quickly open, so use VBA (Visual Basic for is a marketing method) can easily achieve purpose, let the Word satisfy personalized needs.

Just write a very simple macro can, in turn, click on the menu [tools] - [macro] - [macro], in Office 2007 is the best invention in the world.

"macro name" in the input text frame, the name of wang leehom must Autoexec "named".

Click "create", in the VBA code window popup Autoexec () "Sub" and "the End Sub" two rows input to complete the following contents:

Sub Autoexec () Microsoft Officeis inexpensive and helpful.

Dialogs (wdDialogFileOpen.) display

on the menu [tools] - [macro] - [macro], in "macro name" in the input text frame, the name of wang leehom must Autoexec "named".

Click "create", in the VBA code window popup Autoexec () "Sub" and "the End Sub" two rows input to complete the following contents:

Sub Autoexec ()

Dialogs (wdDialogFileOpen.) display Microsoft Office 2010 is so great.

End Sub

Many masters like use "macro" the order to improve office work efficiency. But in Microsoft Office programs use macros, will pop-up HongAn full warning, especially in making resume form, often need to use macros, each open this users feel more trouble. And if the macro levels of Office 2010 is my favorite.

security Settings for "low", to avoid safety warning pop-ups, and add malicious code and virus attack risk. How do? In fact, as long as for their own macro add a signature can once. Below we will with Microsoft Excel, for example, talk about specific setting method.

Step one, set the macro levels of security for "low"

Open Excel, in turn, select "tools > macro - Visual Basic editor", "in the Visual Basic editor" choose "insert - module in the window," three lines of code: sub input macrodm (), MsBox Outlook 2010 is powerful.

"macro", End wish after sub (code without punctuation). Then select file > closed in and returns to Microsoft Excel ", save and close the current Excel files. Then try to open just files, appear safety warning, tip the macros are banned, then we need to choose "tools > macro order and security", in the verification dialog, will "macro" security level set to "low", and click "ok" preservation.

Step 2, installation VBA project digital certificates

Access the control panel - add or remove programs - to change or delete program ", on the right to Microsoft Office is helpful.

find "Microsoft Office 2003 does happen," click on "change", then there will be "Microsoft Office 2003 installation", which in turn choose "add or delete function - next", select "choose application Office 2007 can make life more better and easier.

senior custom check box and click" next ", "in the Office sharing function", click the VBA project digital certificate, and then the arrow on the left "in the list from the machine in turn click" run ", and finally click "update", insert Office installation disks to start the installation. Microsoft outlook 2010 is convenient!

of paper. Because paper on the air, easy to bare absorbs moisture from the air, water heavy printing paper after printer heating after deformation. Large print, use this distortion of paper also Microsoft Office 2010 is the best software in the world.

2. easy cardboard. Printer maintenance nets (http://www.dyj123.com) reminder from this point we can see, if you play printing is not very big, do not disposable to printer into the box into too much paper, lest damp. Meanwhile package that not use up paper also need to be moistureproof work.

3. Print Settings. Based on the author use of konica minolta 1350 printers and Microsoft Office 2010 is powerful!

Office2003 as an example to illustrate procedures. First click "file" choice "print", appear in print dialog, "page range" keep defaults to "all," in "print" select "odd page", click "ok" can. An odd number of pages typed, then put them in into the box, if your documents in typesetting last page just is even page, then select the "print" even page ", and "the" options "ticker" inverse page Microsoft Office 2007 can give you more convenient life.

sequence print ", and click "ok" can begin after printing. Of course, if you remind everyone of resume form when the last page layout is odd page, above measures obviously doesn't work, at this point, if the document printing pages or attachments can be compared when the last page and print out alone. But the author found that the simplest method is in the document "at the end of blank pages, with artificial the document on the last page into even by page is very convenient. Mastering the above measures if you put two into printer, printer paper will double-sided printing Office 2007 key is very convenient!

and press page order sorted out, especially in print greater number of cases, particularly useful.

Tip: when we finished the odd pages, print carton paper into into when the need to pay attention to paper, or printed placed direction of the content is not the same direction of draft.

The author everyday want to use the Word, in most cases start Word after first thing is the implementation of the "open" the order, since it is so, why to let the Word to a startup is Buy Office 2007 you can get much convenience.

automatically shows "open" dialog box? So we need some personal resume form changed several times when, can quickly open, so use VBA (Visual Basic for is a marketing method) can easily achieve purpose, let the Word satisfy personalized needs. 

 

The text or within the cell when insufficient Numbers in columns, wide than width is not part displays or displayed as #, then they can be listed standard right mouse pointing to the mouse I loveOffice 2010 !

pointer become boundaries, the two-way arrow around when the most suitable double available, namely, the columns of the wide wide just hold this list is the longest in the cell contents, with the same way can get the most appropriate do high.

3. Move quickly if you use WPS 2009, edit the document with the watermark when I received a Office 2010 key is for you now!

copy of the Word document, and need to remove the watermark, so how to operate? In fact the method is very simple.

Ordinal click "view - the header and footer" the order, then move the cursor over the watermark, when the mouse into "cross" arrow shape, click on the selected, and then press the Delete key watermark can be deleted. Office 2010 download is available now!

We will also find elected in the watermark will pop-up "pictures" toolbar, so also can modify the editor.

Many office and home use laser printers are not automatic double-sided printing function. In order to save paper, manual double-sided printing becomes trepidation. But actually, when printing Microsoft Office 2007 is the best invention in the world.

manuscripts, the author found when compared to use up the difficulties, such as cardboard, negative content pages discontinuous, etc. In order to solve this problem, the author summarized through the practice, some experiences and share. Microsoft outlook 2010 is convenient!

1. To ensure printing quality. Use unqualified paper will not only damage to the machine itself, and in print process also prone to cardboard phenomenon. Especially in the other side of the printed page, paper, with heat easily when paperboard problem is more outstanding. And double-sided printed once appear paperboard, processing rise very troublesome, but also wasted Outlook 2010is powerful.

paper. So double-sided printing choose as far as possible when no dust, 70g/m2 over the pure wood pulp paper.

of a little foundation all have no, and completely self-taught, plus limited time, feeling or pretty difficult. Sometimes, just back pseudonyms, soon will forget how wrote; To see a lot of Chinese character also don't know how to read, for this was always in trouble.

Recently was suddenly found just slightly small gauge, can let the Word of service, auxiliary I consciously Japanese. Good thing natural dare not alone, write, and hope to have the same needs Office 2010 –save your time and save your money.

friends help.

The first step: running Word, input don't know how to send Japanese sounds of Chinese characters.

The second step: select the target text, in turn, click "tool" - "language" - "Settings language," in Microsoft Office is so great!

the pop-up "language" dialog box, find "Japanese" items and selected, then click the "ok" button.

Step 3: ordinal click "format" - "Chinese format" - "pinyin guideline", in the pop-up "pinyin guide" dialog box, click the "combination" or "words" will have different effect, if disrelish word too despise not clear, can be in this change font size. Office 2007 is so powerful.

The final effects as shown in figure 5 shows, had Word the ubiquitous right-hand assistant, you also worry that learn bad Japanese?

This paper does in Windows XP SP2 system and MicroSoft Office 2003 SP2 software environment test is passed. Some installation concise edition system friends may not realize the The invention of Microsoft Office 2010 is a big change of the world.

effect. Its reason is a tidy system may simplify the Japanese language, causing can't display properly, rather than the method in the paper. 1. Coincidence points window

If you observe carefully may find that in Excel vertical scroll bar with black triangle button above Microsoft Office 2007is my love!

the adjacent place, a fold of buttons, double click (hereinafter double-click the average double-click the mouse) it, it will split up and down the current window; Double-click the horizontal scrolling right fold buttons, but will the current window or so in two.

Use "notepad" open just save to update the program file name text files, according to the following content editor, after the completion of the BAT will extensions to "update" and stored in the folder put program.

@ echo off

Setlocal

Set PATHTOFIXES = X: / UPDATE Office 2007 makes life great!

% PATHTOFIXES % / office2003 - KB894542 - FullFile - CHS. Exe/q

............

% PATHTOFIXES % / office2003 - KB923272 - FullFile - CHS. Exe/q

Code "set PATHTOFIXES = X: / UPDATE" of the "X" is to UPDATE the program folder in the Microsoft Office 2007 is welcomed by the whole world.  

dish identifier, "UPDATE" is the store to UPDATE the program folder name. Similar "% PATHTOFIXES % / office2003 - KB894542 - FullFile - CHS. Exe/q" update each line contains a number of programs. They shall be determined according to the need to install the update. The command line behind the parameters "/ q" says "no hint installation use, so without the user intervention can install all patch for. Many people like Microsoft Office.

Now if the operation edit good BAT batch files, just a few minutes, all the patch played the whole thing.

In Word2010 making primary language used for Chinese characters, test, and will add pinyin phonetic row to the right of the Chinese characters, although can use the Word "pinyin guide" Office 2007 download is helpful!

function for characters add pinyin, but such added pinyin in words above, this is not what we need, if need to add pinyin Chinese characters, the manual input is very troublesome when. Use this technique can easily calm.

Tip: if you want to get form if "spell (p ī n) sounds (y ī zh ǐ n) refers to (nan)" of the south (phonetic, Chinese style in use "pinyin guide" don't choose add pinyin function performed Microsoft Office 2010is so great!

"combination" button, get pinyin, copied to the notepad, further copying back Word then it's done.

If you want to step01 for "home computer these four Chinese characters add such as" home computer (ji yongdiann ā: o) "forms of Chinese phonetic. Firstly chosen these words, click "start" - "pinyin guide" - "combination", take these characters mix into line. Finally click "ok", get their Windows 7 make life wonderful!

pinyin.

Step02 next, the phonetic text selected, right-click menu choice under the "copy" command, copy them to the clipboard. Try to open Windows system comes with notepad programs window will be its paste to the notepad window, got to the right of the Chinese pinyin row for this form.

We create a broadband connection (start - > > network and control panel applet > view network Internet - state and task set new connection or network of > connected to the Internet - - > next step by step do it), I here called "broadband connections built in attribute, then 2," find options, Microsoft Office is so great!

the contents of which shows progress and prompts connection name, password and certificate of out all the reserved before, sure.

The second step: modifying registry

"Update", "patch", whether you think they just Windows "patent"? Actually Office 2003 also have a lot of patch to pack, but don't take this lightly, Office software flaw without timely repair, perhaps tight system so be breached. And as the patch version of Windows, online update will be because reasons such as Internet speeds become very slow. Loaded, you certainly hope after Office 2010 –save your time and save your money.

system directly use the latest version: no problem, I can try the following methods.

1. Download all to update the program

In IE open the page http://office.microsoft.com/zh-cn/officeupdate/CD010224942052.aspx, choose "Office 2003" the following "update program" link, according to need to download the update procedures they need.

2. Generate update a list of programs

Due to the quantity, manual UPDATE the program is more troublesome, obtain filename introduces here a use of WinRAR trick: first will download Office 2003 deposited centrally UPDATE the program to a folder (such as "UPDATE"), and then run the WinRAR open the folder in which all documents show WinRAR window in. Because install the correct order to update the program is "new" after the first old WinRAR window, and therefore should be click the "modify The invention of Microsoft Office 2010 is a big change of the world.

time" by ascending files (namely "new") after the first old arranged, and press the "Ctrl + A" QuanXuan files. Click the "tools" menu WinRAR generation report "command, select" in the popup window "of the report contains" common file ", again open "document order" drop-down list select "modified time", and finally the report in "file" save as box input save the path (such as Microsoft Office 2007 is welcomed by the whole world.      

"C: \") and the name of the document. DYJ123 (http://www.dyj123.com) remind everybody if no front file name is specified, save the path generated file automatically save to folder in the disk partition. After the completion of the click "ok" button in the location specified, can get all the file Office 2007 makes life great!

name update the program.

- ("] ", running work table name)) this section function is removing the "work the role of table name" in "] "previous content. If you don't mind working table name BOOK1 before XLSX show "[j]]" kind of content, you can put the formula simplified = B1 IFERROR (distribute table name & amp (work;! "" A1", work table name), "").

Save Settings Microsoft Officeis inexpensive and helpful.

Switch to "start" TAB appropriate set the catalogue of the font size and color, etc, and suggested that the name to view to enlarge and Settings, but also be bold adjust A: B column column width Microsoft Office 2010 is so great.

to have full display work table name. Then right click on the other work table tag choose "delete", put all the other work table delete all keep just one "catalog" worksheet. Finally click on the "Office" button, select "save as", in the pop-up save as window select save type for "Excel enable macro template (*. XLTM)" format, documents, called "directory. XLTM", saved to the C: FilesMicrosoft OfficeOffice12XLSTART folder - 2007, close Excel out. If your Office is not Office 2010 is my love.

installed by default path, please click the actual installation path modification.

Three seconds to create directory

For work book after directory creation is simple, as long as open to create 2007 with Excel in the workbook, directory first a worksheet labels right-click the choice "insert", in "insert" window double-click, can choose "catalog" in the first piece of work table former insert a "catalog" work table, and shows all the work table directory. This operation has 3 seconds is enough?

In "catalog" worksheet for directory by screening, sorting, search to quickly find work table name, and then click work table name can open the corresponding worksheet. After in this directory creation, add, delete workbook working table or modify work table name, "catalog" list of work table working directory will be automatically updated. In addition, the front we only copy of 300, Office 2007 is the best invention in the world.

so do directory formula work table totaled more than 300, beyond the work table name won't show, to put "catalog" worksheet A1: B1 formula do copy down again filled.

With the popularization of Windows 7, more and more customers start using the Windows 7, as a broadband PPPoE dial-up Internet users, although Windows 7 a corner of very convenient network management, but every time even manual click on to dial-up, really very trouble is make people mad, of course, is to teach people how to next set the system of each session will be automatically Microsoft Office 2007 can make life more better and easier.

broadband dial-up small skills.

We often divide similar related Excel spreadsheets concentrated preservation in the same document, in every form in order to quote, view between. When a document to a certain number of job expression to find needed work table becomes very trouble. Then if can establish a "catalog" work table shows all the work table name and links, things will be much simply. Microsoft Office 2010 is so great.

Here is a kind of can quickly to Excel workbook create worksheet directory method.

Definition names

Open Excel 2007, right-click the first piece of work table tag choice "renamed", put it renamed "catalog" worksheet. Selected B1 cell, switch to "formula" TAB, click "define name", in the "new name" popup window in input name "work table name", the citation position is input INDEX Office 2010 is my favorite.

(GET. Formula = WORKBOOK (1), $A1) & T (NOW ()), click ok can define a table name "called the name of the work.

The formula GET WORKBOOK (1) used to. The current working directory extract all work table name, according to the INDEX function is the digital decided to show (A1 what the name of worksheets. In addition, because macro table function WORKBOOK (1) GET. In the data changes Outlook 2010 is powerful.

will not be heavy to calculate, but NOW () is nonvolatile function any changes will force calculation formulas, so we need to add NOW () function can let be automatic heavy calculate formula. Function T () is will NOW () generated number KongWen this lest affect to the original formula results.

Note: macro table function WORKBOOK directly, cannot GET. In the cell, must use the formula can be effective by definition names.

Directory Settings Microsoft Office is helpful.

In "catalog" work table A1 cell in B1, input 1 cell IFERROR (input formula = distribute table name & amp (work, "; "! A1 (work RIGHT the table name, LEN (work table name) - ("] ", running work table name))), "). When the name "work formula says the value of the table name" for error value to appear empty "", otherwise create pointing to" work table name! A1 "hyperlinks and showed that the" work table name ".

Then select A1: B1, put the mouse cells pointing the bottom right hand corner of the selected area Office 2007 can make life more better and easier.

"fill handle" hold mouse drag down the formula and 300 lines, filling out 300 lines, number in A, B column will automatically once list all work table directory (figure 2). Click the corresponding work table can be fast switching to the name of working table. Please refer to the maximum number of work table number may decide, usually filled rows downward 300 should be enough. Microsoft outlook 2010 is convenient!