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)