"令" vs "让" vs "使"

if you want to express " to make" or "to cause", you can use "使". The using way of "令" and "使" is same in your example. 

The "让" , you can use it too, it's same too in your example, but it have other meaning, such as "let" , it means "to order" , check this:

是他让我把椅子放在这儿的！
(He let me put the chair here!)

In this case, it's strange to use "令" and "使". because they do not have a mood or a condition of "to order" .

The "令", though this one word have a "to order" meaning, it just be the noun. if it be the verb, it means "to make", not "to order" or "to let".

if you still be unclear to use these words, you can think about that: 
when you want to change something or someone to do something, you can use all; 
when you want to order or to let someone to do something , you can use "让"

And, the "令" is used usually in writing.

(Original website: http://www.italki.com/answers/question/66477.htm?hl=zh-tw)

Excel 註解也可以列印

Excel 有【註解】的功能，但有時候會想要在列印時連【註解】一起印出，但預設值無法列印【註解】，這裡教你如何連同【註解】一起列印 Excel 報表。

在功能表上選【檔案】→【版面設定】→ 切換到【工作表】頁籤 → 選擇 【註解(M):】後面的三角形按鈕。

這裡有三個選項：

• 【無】 → 預設值
• 【顯示在工作表底端】
• 【和工作表的顯示狀態相同】

一般選擇【和工作表的顯示狀態相同】。

設定完成後，【註解】真的列印出來了。

※注意：欲列印【註解】時，不能從【預覽列印】→【設定】的地方設定，一定要從【版面設定】的地方進去才可以設定。須要先設定【顯示註解】，否則

(Original website: http://mymoneylook.blogspot.com/2008/12/excel-excel.html)

各种组织机构名称翻译法

1) 政府官方机构包括中央政府部门与各级地方政府部门。国务院以下各级国家机构由委 (Commission)、部 (ministry) 、司 (department) 、局 (bureau) 、处 (division) 、所 (institute) 、 科 (section) 、中心 (centre) 、室 (office) 等组成。各机构部门职责分工不同，历史沿革不同，因而机构名称不尽相同，其英译也有差异。有些政府部门有约定俗成的简略语，如国家教委(国家教育委员会)、国家计委 (国家计划委员会)。翻译这些简略语需将其全称意译成英语，例如：
全国人民代表大会 the National People's Congress
常设委员会the Standing Committee
中国人民政治协商会议 the Chinese People's Political Consultative Conference
国务院 the State Council
国家计委 the State Planning Commission
国家教委the State Educational Commission
外交部 the Ministry of Foreign Affairs；the Foreign Ministry
财政部the Ministry of Finance
文化部the Ministry of Culture
商业部the Ministry of Commerce
外事局the Bureau of Foreign Affairs
行政处 the Division of Administration ; the Administrative Division
秘书处the Secretariat
人事处 the Division of Personnel；the Personnel Division

2) 地方政府机构包括省、地、市、县等各级政府及其下属机构部门，有委 (commission)、厅 (department)、局 (bureau)、公司 (company)等，其名称采用意译方法，例如：
省教委 the Provincial Educational Commission
省民政厅 the Provincial Department of Civil，Administration
省监察局 the Provincial Supervisory Bureau
省审计局 the Provincial Auditing Bureau
省进出口公司 the Provincial Import and Export Company
地农业局 the Prefectural Agricultural Bureau
地税务局 the Prefectural Tax Bureau
市体委 the City／Municipal Physical Culture and Sports Commission
市文委 the City／Municipal Cultural Commission
市公用局 the City／Municipal Public Utility Bureau
市商品检验局 the City／Municipal Commodity Inspection Bureau
市邮政总局the City／Municipal General Post Office
市保险公司 the City／Municipal Insurance Company
县工业局the County Industrial Bureau
县林业局 the County Forestry Bureau

3) 社会团体单位 (如工厂、商店、医院、公司、大学、中小学、出版社等)，其名称一般采取意译方法，例如：
南京大学 Nanjing University
北京四中 Beijing No．4 (number four) Middle School
北京第一实验小学 Beijing No．I (number one) Experimental Primary Elementary School
武汉钢铁公司 Wuhan Iron and Steel Company
杭州万向节厂 Hangzhou Universal Joints Factory
北京301医院 Beijing No．301 (number three 0 one) Hospital
北京动物园 Beijing Zoo

4)专业组织和民间组织名称，一般也采用意译方法，例如：
市消费者协会the Municipal Consumers’ Association

5)国际主要经济贸易组织协会名称翻译
National Council for US-China Trade 美中贸易全国理事会
Japan-China Economic Association 日中经济协会
Association for the Promotion of International Trade, Japan 日本国际贸易促进会
British Council for the Promotion of International Trade 英国国际贸易促进委员会
International Chamber of Commerce 国际商会
International Union of Marine Insurance 国际海洋运输保险协会
International Alumina Association 国际铝矾土协会
Universal Postal Union, UPU 万国邮政联盟
Customs Co-operation Council, CCC 关税合作理事会
United Nations Trade and Development Board 联合国贸易与发展理事会
Organization for Economic cooperation and Development, DECD 经济合作与开发组织
European Economic Community, EEC, European Common Market 欧洲经济共同体
European Free Trade Association, EFTA 欧洲自由贸易联盟
European Free Trade Area, EFTA 欧洲自由贸易区
Council for Mutual Economic Aid, CMEA 经济互助委员会
Eurogroup 欧洲集团
Group of Ten 十国集团
Committee of Twenty(Paris Club) 二十国委员会
Coordinating Committee, COCOM 巴黎统筹委员会
Caribbean Common Market, CCM, Caribbean Free-Trade Association, CARIFTA
加勒比共同市场（加勒比自由贸易同盟）
Andeans Common Market, ACM, Andeans Treaty Organization, ATO 安第斯共同市场
Latin American Free Trade Association, LAFTA 拉丁美洲自由贸易联盟
Central American Common Market, CACM 中美洲共同市场
African and Malagasy Common Organization, OCAM 非洲与马尔加什共同组织
East African Common Market, EACM 东非共同市场
Central African Customs and Economic Union, CEUCA 中非关税经济同盟
West African Economic Community, WAEC 西非经济共同体
Organization of the Petroleum Exporting Countries, OPEC 石油输出国组织
Organization of Arab Petroleum Exporting Countries, OAPEC 阿拉伯石油输出国组织
Commonwealth Preference Area 英联邦特惠区
Centre National du Commerce Exterieur, National Center of External Trade 法国对外贸易中心
International Bank for Reconstruction and development, IBRD 国际复兴开发银行
World Bank 世界银行
International Development association, IDA 国际开发协会
International Monetary Found Agreement 国际货币基金协定
International Monetary Found, IMF 国际货币基金组织
European Economic and Monetary Union 欧洲经济与货币同盟
European Monetary Cooperation Fund 欧洲货币合作基金
Bank for International Settlements, BIS 国际结算银行
African Development Bank, AFDB 非洲开发银行
Export-Import Bank of Washington 美国进出口银行
National city Bank of New York 花旗银行
American Oriental Banking Corporation 美丰银行
American Express Co. Inc. 美国万国宝通银行
The Chase Bank 大通银行
Inter-American Development Bank, IDB 泛美开发银行
European Investment Bank, EIB 欧洲投资银行
Midland Bank Ltd. 米兰银行
United Bank of Switzerland 瑞士联合银行
Dresden Bank A.G. 德累斯敦银行
Bank of Tokyo Ltd. 东京银行
Hong Kong and Shanghai Corporation 香港汇丰银行
International Finance Corporation, IFC 国际金融公司
La Communaute Financieve Africane 非洲金融共同体
Economic and Social Council, ECOSOC 联合国经济及社会理事会
United Nations Development Program, NUDP 联合国开发计划署
United Nations Capital Development Fund, UNCDF 联合国资本开发基金
United Nations Industrial Development Organization, UNIDO 联合国工业发展组织
United Nations Conference on Trade and Development, UNCTAD 联合国贸易与发展会议
Food and Agricultural Organization, FAO 粮食与农业组织, 粮农组织
Economic Commission for Europe, ECE 欧洲经济委员会
Economic Commission for Latin America, ECLA 拉丁美洲经济委员会
Economic Commission for Asia and Far East, ECAFE 亚洲及远东经济委员会
Economic Commission for Western Asia, ECWA 西亚经济委员会
Economic Commission for Africa, ECA 非洲经济委员会
New York Stock Exchange, NYSE 纽约证券交易所
London Stock Market 伦敦股票市场
Baltic Mercantile and Shipping Exchange 波罗的海商业和航运交易所


(Original webpage: http://www.oktranslation.com/Cms/Article.aspx?ArticleID=25092)

投資者要克服的五大恐懼心理

《華爾街日報》 －新聞頭條壞消息不斷，道指以500多點的幅度波動，經濟前景黯淡不明，這些因素都讓投資者望而生畏。雖然擔憂可能確有其事，但財務顧問們說，如果因為恐懼而不積極進行投資，那你未來的財富積累將受到影響。

1. 股指回到原點

威斯康星州布魯克菲 爾德市(Brookfield)的財務顧問科特羅茲曼(Kurt Rozman)最近跟一位客戶見面。那人認為，標準普爾500指數將在2012年末「一切歸零」，如果他不馬上清倉離場，就會「淨身出戶」。

羅茲曼說：「他預想的是一個極端不現實的場景。」

羅茲曼向這位客戶解釋，要想讓標普500指數歸零，全美前500大上市企業必須在同一時間破產，而這極不可能發生。

夏威夷卡帕島(Kapaa)的金融心理學家布萊德克隆茲(Brad Klontz)說，如果有客戶確信「世界末日」就要來臨，他會引導這位客戶多做幾次深呼吸，並在心裡默念「放鬆放鬆」這樣的詞句。然後，客戶可以評估一 下自己的想法是否切合實際，並尋找支持或推翻這一立場的證據。克隆茲說：「你腦海裡出現的想法，不一定就是真的。」

他還建議客戶三思而後行，不要一有衝動就採取行動，這樣就能減少個人情緒對投資決策的負面影響。

2. 短期市場波動

紐約(新聞 - 網站 - 圖片)州斯卡斯代爾市(Scarsdale)的註冊理財規劃師本蘇利文(Ben Sullivan)說，他一個客戶24歲的兒子近三個月來損失了400美元，就決定「賣出所有股票」。有些客戶的年輕成年子女不太願意投資所在公司的 401(k)退休計劃，因為同事們對市場波動的憂慮讓其對投資前景缺乏信心。

蘇利文說，雖然投資者難以消化股市跌500多點的消息，但清倉離場或不再投資401(k)計劃會是一個大錯誤。

蘇利文說：「如果你未來還有20到40年的投資時間，等待進場時機可能比承受短期虧損所冒的風險更大。」

蘇利文鼓勵那個24歲的年輕人堅守自己的投資策略，並記住一點，等他退休時，這400美元的損失肯定「早就忘得一幹二淨了」。

3. 投資陌生領域

密蘇裡州聖路易市(St. Louis)的投資顧問傑拉德凱澤(Jared Kizer)說，在某些情況下，對陌生領域的投資恐懼可能是件好事，因為有些金融產品過於復雜，投資者搞不懂，還是敬而遠之為好。

不過，如果一味躲避陌生領域，投資不夠多元化，投資者可能難以實現自己的長期收益目標。

凱澤說，只選擇自己熟悉的投資品種也許會導致意想不到的投資風險。

凱澤對此的解釋是：如果有人將一輩子的積蓄都用來購買自己所在公司的股票，那還不如投資於多元化的資產類別，這樣才有更好的機會實現自己規劃的退休目標。凱澤分享了幾個投資者的失敗案例，他們把賭注都押在自己所在公司的股票上，結果公司破產，血本無歸。

4. 錯失市場機會

北卡羅萊納州教堂山市(Chapel Hill)的注冊理財規劃師詹姆斯米勒(James Miller)不斷接到客戶來電，詢問是不是應該「現在離場觀望，等安全一點再進來」。

米勒告訴這些客戶，選擇投資時機並不能解決問題。他提醒客戶說，等情況看上去比較「安全」的時候，市場可能已經到了一個比現在高得多的點位，等那時再投資，客戶將失去很大一塊資產增值的空間。

5. 沒有足夠資金

俄亥俄州查格林福爾斯市(Chagrin Falls)的註冊理財規劃師康斯坦絲斯通(Constance Stone)說，如果客戶的債務負擔很重，現金流很少，他們經常就會覺得沒有足夠的資金來做投資。

斯通說：「之所以造成這種局面，往往是因為這些客戶的消費方式不太理性。」

斯通最近幫助一對三十歲出頭的夫妻嚴格控制每月消費，尋找削減開支的各種方法，以便其能償還13.2萬美元的信用卡債務和助學貸款。這對夫妻最終意識到，少去餐廳吃飯，開源節流，他們能夠存下錢來，為退休做好準備。

「千裡之行，始於足下，要從點滴做起。」斯通說。

撰稿：華爾街日報VERONICA DAGHER


(Original webpage: http://hk.biz.yahoo.com/120110/364/4e43h.html)

別讓上司擋住你的成功之路

《華爾街日報》 －我們都希望事業蒸蒸日上，但你的上司會希望你這樣嗎？

松下電器印度(新聞 - 網站 - 圖片)公司（Panasonic India Pvt）的人力資源與集團事務總監普拉山特德奧辛格（Prashant Deo Singh）說，不一定。

辛格說，許多管理者都對工作沒有安全感，因此他們不願讓下屬表現搶眼。相反，他們可能會搶員工的功勞。如果有可能，這種管理者還會避免聘用他們認為可能取代他們的人。

他說：「這是管理者犯的最嚴重的錯誤之一。」

《華爾街日報》：管理者們最常犯的錯誤是什麼？

辛格：許多管理者都有控制欲。這是打擊員工積極性的重要原因。管理者需要知道，人們討厭被控制。

我們也看到過許多沒有安全感的管理者。他們往往會匿藏訊息，不讓下屬的工作得到公司的承認。他們可能給團隊成員指派較少的工作，或者不投入他們的培訓。

這種上司可能更喜歡不會挑戰其權威的員工。他們甚至會由於擔心員工取代他們，而不聘用比他們聰明的人。這些就是管理者們可能會犯的嚴重錯誤。

此外，有些管理者並不在意員工的需求，可能還會羞辱他們，這是不對的。人都應該得到尊重。

《華爾街日報》：那麼，員工該如何與沒有安全感的上司相處呢？

辛格：首先，應該直接面對你的上司，指出他對你不公平的地方。譬如說，如果上司沒有給你充足的機會，或者搶了你的功勞，你應該說出來。

如果可能，在你的上司的上級在場的會議或論壇上努力展現你的工作。如果這不管用，那麼可以考慮向你上司的上司報告他的行為。

不過，當你評價上司時要公正。不要僅憑一兩件事就做出判斷。如果你真的認為你的上司妨礙了你的事業發展，那麼作為最後一招，你可以考慮換工作。

《華爾街日報》：好上司應該是什麼樣的？

辛格：好上司是能夠激勵員工，給他們空間並信任他們的人。他們會根據員工需求變換管理風格。年輕員工可能需要手把手地教，而資深團隊成員則需要自主權。

此外，好的管理者會給員工提供實現期望業績所需的工具和指導。管理者需要關心團隊成員並確保他們的事業有進步，而且，與員工建立私人關係也很重要。

《華爾街日報》：轉換一下話題，全球經濟衰退對貴公司的招聘計劃有何影響？2012年消費品行業的招聘前景如何？

辛格：從全球看，由於全球經濟環境的變化，松下公司已裁員，但印度分公司沒有受到影響。

我們已經實現了2011年招聘600位銷售、市場營銷和製造部門員工的目標。我們在印度的銷售收入正在增長，而且我們正在通過開設新的分公司和新商店進行積極投資。

從長遠角度看，松下印度也計劃踏入太陽能和環境相關業務領域，這會創造新的工作機會。從整個消費品行業來看，2012年不會有積極的招聘動作，因為各家公司現在都很關注成本。

《華爾街日報》：在面試中，你最看重應聘者的哪兩點？

辛格：第一，應聘者的眼光是否能超越個人利益。我們尋找的是能進行團隊合作、而不會太以自我為中心的人。

儘管雄心很重要，但野心太大、太貪心也是有害的。我們更關注情商和工作經驗，而不是智商。高智商的人往往很追求物質。我們希望員工不僅是好的執行者，還同樣擅長人際交往。

第二，我們要招聘的是不僅能完成眼前工作、還能勝任長遠發展的人。我們根據應聘者是否適合擔任5-10年後的公司工作來評價他們。我們會自問「如果這個人對市值10億美元的公司來說很合適，那麼他對市值20億美元的公司來說合適嗎？」

《華爾街日報》：你最討厭應聘者哪一點？

辛格：傲慢、自負、沒有耐心。我們不需要尋找成功捷徑的人。

我最近面試過一位優秀的大學生，他說他希望成為一位「高淨值」的人。顯然，這是一個傲慢的回答。這與我們謙恭禮讓的指導原則不符。

《華爾街日報》：你們有哪些招聘員工的途徑？

辛格：我們70%的招聘是通過員工推薦進行的。還有15%是通過職場顧問，剩下的則是通過校園招聘和專業求職網站進行的。

我們的員工中，一半是研究生以上學歷，其中的管理學研究生被分進了銷售部門和市場營銷部門。

撰稿：華爾街日報Nikita Garia



(Original webpage: http://hk.biz.yahoo.com/120110/364/4e445.html)

Return an Excel Worksheet Name to a Cell

In Excel it is possible to use the CELL function/formula and the MID and FIND to return the name of an Excel Worksheet in a Workbook. The formula below shows us how;

=MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,256)

(Read the whole passage: http://www.ozgrid.com/VBA/return-sheet-name.htm)

FastestChrome - Browse Faster

FastestChrome is easy to use. Simply look at the previews above. All features are configurable via options.



==Details==
★ Endless Pages automatically loads the next page just before you reach the end so you don't have to click "Next" or wait
★ To open searches in a new tab middle click the icon
★ Look up definitions instantly by highlighting a word
★ Hover over a link to see how popular it is on Facebook and Twitter (now off by default, go to Options -> Show link info to enable)
★ Better Google: shows you relevant results from real-time and shopping search engines such as OneRiot and Amazon
★ Search more conveniently: select text then click on a search engine to search
★ Automatically turns text URLs into links
★ Adds related articles to Wikipedia
★ **To disable Superfish slide-ups** go to chrome://extensions/ -> FastestChrome -> Options

Note: for security reasons no extensions are allowed to work on these Gallery pages.

(Read the whole page: https://chrome.google.com/webstore/detail/mmffncokckfccddfenhkhnllmlobdahm?hl=en)

Add a secondary vertical axis

You can plot data on a secondary vertical axis one data series at a time. To plot more than one data series on the secondary vertical axis, repeat this procedure for each data series that you want to display on the secondary vertical axis.

1. In a chart, click the data series that you want to plot on a secondary vertical axis, or do the following to select the data series from a list of chart elements:

1. Click the chart.

This displays the Chart Tools, adding the Design, Layout, and Format tabs.

2. On the Format tab, in the Current Selection group, click the arrow in the Chart Elements box, and then click the data series that you want to plot along a secondary vertical axis.

2. On the Format tab, in the Current Selection group, click Format Selection.

The Format Data Series dialog box is displayed.

 NOTE   If a different dialog box is displayed, repeat step 1 and make sure that you select a data series in the chart.

3. On the Series Options tab, under Plot Series On, click Secondary Axisand then click Close.

A secondary vertical axis is displayed in the chart.

4. To change the display of the secondary vertical axis, do the following:

1. On the Layout tab, in the Axes group, click Axes.
2. Click Secondary Vertical Axis, and then click the display option that you want.

5. To change the axis options of the secondary vertical axis, do the following:

1. Right-click the secondary vertical axis, and then click Format Axis.
2. Under Axis Options, select the options that you want to use.

 TIP   To help distinguish the secondary axis, you can change the chart type for just one data series. For example, you can change one data series to a line chart. For more information, see Present your data in a combination chart.

(Read the whole passage: http://office.microsoft.com/en-us/excel-help/add-or-remove-a-secondary-axis-in-a-chart-HP001234165.aspx)

DownThemAll alternative in Chrome: Download All

Download All David Vavra (Destil) Free

Allows to download multiple files linked to any webpage at once.

Description

If you have multiple links to files at any webpage, this extension can help you. You specify file-type and the extension downloads all occurrences of this file-type. It's easier than 'Right click -> Save as' to all the files. 

NOTE:
Extension downloads just files which are not opened in Chrome by default (left click to file). So for example:

WORKS: zip, doc, xls, ppt, avi, tgz, java, rar, docx, ...
DOESN'T WORK: mp3, pdf (unless Adobe Reader is uninstalled), txt, jpg, png, ...
(these files are opened in new tabs instead of downloading, can be customized in settings)

(Read the original page: https://chrome.google.com/webstore/detail/dichiooocmfaijgfjjohpjdbelmficee)

MS Excel: Transpose Function

In Excel, the Transpose function returns a transposed range of cells. For example, a horizontal range of cells is returned if a vertical range is entered as a parameter. Or a vertical range of cells is returned if a horizontal range of cells is entered as a parameter.
The syntax for the Transpose function is:

Transpose( range )

range is the range of cells that you want to transpose.

Note:

• The range value in the Transpose function must be entered as an array. To enter an array, enter the value and then press Ctrl-Shift-Enter. This will place {} brackets around the formula, indicating that it is an array.

Applies To:

• Excel 2007, Excel 2003, Excel XP, Excel 2000

For example:

Let's take a look at an example:

Based on the Excel spreadsheet above:
We've placed values in cells A1, A2, and A3, and we'd like to view these values in cells C1, D1, and E1 (transposed). To do this, you highlight cells C1, D1, and E1, then enter the following formula:

=TRANSPOSE(A1:A3)

Then press Ctrl-Shift-Enter to create an array formula. You will notice that {} brackets will appear around the formula and the values in cells A1, A2, and A3 should now appear in cells C1, D1, and E1.

Frequently Asked Questions

---

Question:  In Excel, isn't it easier to use the Paste Special transpose option to do the same?
Answer: Yes, if you ONLY want to perform a one-time paste of the values, you can do the following:

Highlight the cells that you want to copy. In this example, we've highlighted cells A1:A3. Then right-click and select Copy from the popup menu.


Then right-click on the cell where you'd like to paste the values and select Paste Special from the popup menu.


Then select the Transpose checkbox and click on the OK button.


Now when you return to your spreadsheet, you'll see that the values have been copied and transposed.


(Read the whole passage: http://www.techonthenet.com/excel/formulas/transpose.php)

MS Excel: Cell Function

In Excel, the Cell function can be used to retrieve information about a cell. This can include contents, formatting, size, etc.
The syntax for the Cell function is:

Cell( type, range )

type is the type of information that you'd like to retrieve for the cell. type can be one of the following values:

Value	Explanation
"address"	Address of the cell. If the cell refers to a range, it is the first cell in the range.

(Read the whole passage: http://www.techonthenet.com/excel/formulas/cell.php)

Option Explicit

Q. How to avoid incorrectly typing the name of an existing variable?

A. Use Option Explicit statement at file level to force explicit declaration of all variables in the script:

Option Explicit

Option Explicit statement must appear in a script before any procedures.

When you use the Option Explicit statement, you must explicitly declare all variables using the Dim, Private, Public, or ReDim statements. If you attempt to use an undeclared variable name, an error occurs:

Dim myVar
myVar = 1
myNewVar = 0 ' ERROR: Variable not defined.

(Read the whole passage: http://www.excely.com/excel-vba/option-explicit-statement.shtml)

可以highlight重點的PDF reader

一個不錯的軟體：PDF XChcange viewer，可以highlight重點，比 Foxit Reader及Adobe Reader好用。


PDF XChange viewer… 多國語系版, 免安裝版
http://www.portablefreeware.com/?id=1436


(Read the original webpage: http://bigfool.wordpress.com/2010/01/09/%E5%8F%AF%E4%BB%A5highlight%E9%87%8D%E9%BB%9E%E7%9A%84pdf-reader/)
(Original software webpage: http://www.tracker-software.com/product/pdf-xchange-viewer)

"in accordance with" VS "pursuant to" VS "according to"

"pursuant to" must follow some other action. "Pursuant to the new regulations recently passed regarding bubble gum-blowing, no bubbles may be blown that exceed 3 inches in diameter."

"according to" is citing a reference. "According to the Bible, in the beginning was the Word."

"in accordance with" is "in line with", "in agreement with" -- "in accordance with your wishes, I will no longer quote the Bible while blowing bubbles."

(Read the whole passage: http://forum.wordreference.com/showthread.php?t=233835)

VBA: Turn off Screen Updating

As cool as it looks watching your macro manipulate the screen, you can help it run faster if you turn off Screen Updating.

1. At the beginning of your code put this line:

Application.ScreenUpdating = False

2. At the end of your code put this line:

Application.ScreenUpdating = True

(Read the whole passage: http://www.automateexcel.com/2004/08/14/excel_vba_turn_off_screen_updating/)

USB手指裡"Spotlight-v100"、".TemporaryItems"和"Trashes"是什麼?

Q:

有幾個特別的(和一般的檔案沒關係), 放在隨身碟的目錄底下, 檔名是:

.Spotlight-V100

._.TemporaryItems

._.Trashes 

A:

那是mac os底下的檔案預覽檔（在mac os裡是看不到的）

若是不介意的話，留著無所謂，刪掉了對檔案也不會有影響

不過下次用mac瀏覽檔案的話，又會再出現

(Read the whole passage: http://macuknow.com/node/1333)

Trademark filed in Hong Kong is registered for 10 years

A mark registered under the Trade Marks Ordinance (Cap. 559) shall be registered for a period of 10 years beginning on its date of registration. For example, if the date of registration for your mark is 10 September 2003, it shall be registered for an initial period of 10 years until 9 September 2013. You should renew your mark during the six-month period ending on the date of expiry, i.e. latest by 9 September 2013.

The registration of the mark may be renewed for further periods of 10 years. In the above example, if you renew your mark for a further period, the next expiry date will be 9 September 2023 (assuming all the above dates are business days).

(Read the whole passage: http://www.ipd.gov.hk/eng/faq/trademarks/tm_cap559.htm#a22)

「大股東名單」 vs 「大股東綜合名單」

1. 「大股東名單」提供的是甚麼資料?

「大股東名單」顯示的，是上市法團所有曾於指定日期(即所輸入的結束日期)之前發出通知的大股東名單，以及大股東就該上市法團所呈交的最新一份通知。

大股東名單並將包括：

• 已填報個人大股東通知(表格1)或法團大股東通知(表格2)的人士；
• 己填報董事/最高行政人員通知 — 上市法團的股份權益(表格3A) 並披露持股5%或以上的董事。

2. 「大股東綜合名單」提供的是甚麼資料?

集團的最終控股公司又或控制一系列同集團公司的人士，可能會因為其所控制的法團或同系公司(下稱「受控法團」)擁有某上市法團股份的原故，而同時擁有該等股份權益。受控法團本身可能也因為其股份權益而份屬大股東，因而也填報了有關通知。因此，完整的大股東名單上將會同時見到最終控股公司和有關受控法團。

所謂「綜合」，是指「大股東綜合名單」只顯示份屬大股東的最終控股公司或控制一系列同集團公司之個別人士。這不包括在搜尋日期前已存檔之通知中被指為「受控法團」的大股東；並無透過受控法團持有權益的大股東則不受影響，仍會在此名單上出現。名單並會顯示上市法團大股東所呈交的最新一份通知。

(Read the whole passage: http://sdinotice.hkex.com.hk/di/notes/NSSrchCorpList_C.htm)

How to Write a Self Introduction Letter as a New Colleague to All Staff on Your First Day

Instructions

1. • 1
     Open with a casual salutation, but don't get too relaxed. "Hi everyone," is an appropriate greeting, while " 'Sup team?" might raise a few disapproving eyebrows.
   • 2
     Provide your full name, department and position in the first line of your opening paragraph. For example: "My name is Sarah Best, and I just recently joined the marketing department as the new communications coordinator."
   • 3
     Say how excited you are to learn about the company and get started in your new role. Mention that you're looking forward to meeting more of your colleagues as you settle in during your first week: "I'm really excited to join Company X and I can't wait to start contributing my part to recent rebranding efforts here. I hope to meet many of you in person as I settle in and learn more about the company."
   • 4
     Outline one or two of your most recent positions and list any areas of expertise: "I come to you with three years of experience as a marketing assistant in a collateral production role at Company Y. I'm particularly interested in branding and customer relationship management." If you recently finished college and you don't have much professional experience, use this paragraph to describe your program, when you graduated and any honors you earned as a student.
   • 5
     Provide your personal interests and hobbies in a separate paragraph. Don't go overboard -- one or two should be enough to give colleagues a glimpse of your personality. It's OK to take on a more lighthearted tone. For example, "When I'm not slaving away in Photoshop, I like to take to the great outdoors. You can find me hiking the trails near my house or camping with my family during my off hours."
   • 6
     Describe where you sit so new colleagues can find you and introduce themselves. If you're free for lunch, consider extending an open invitation to your workmates: "If you have a minute and want to stop by to say hello, you can find me in the Chicago office in the cubicle next to the water cooler. I'm heading out for lunch at Ethel's at 1. Stop by my cube if you want to join me and we can walk down together."
   • 7
     Close with a statement that emphasizes how eager you are to work with everyone and sign the email with your first name: "Thanks to everyone for being so welcoming. I look forward to working with all of you."

(Read the whole passage: http://www.ehow.co.uk/how_8395769_write-colleague-staff-first-day.html)

How do I make mouse scroll wheel work in excel

Q: 
Mouse SCROLL WHEEL works in all other office 2007 products but not in Excel.
Is there some hidden setting to make this work?

A:
I was having the same problem. To fix the issue:

1) Goto Control Panel > Mouse> Wheel Tab
Note: This may vary depending on your version of Windows OS.

2) There should be an Exceptions button or tab there.

3) Give a name of your choice and Browse and add Exel.exe. Click OK.

Click Apply and lastly click OK... you're done!

(Read the whole passage: http://www.excelbanter.com/showthread.php?s=8ad69632c73248f7ec3c1f4bd45538f0&t=224310)