Get Rid of the "Enable Macros" Notice

Have you ever opened an Excel Workbook that no longer contains macros but it still prompts you to "Enable or Disable Macros"? 

Here's why:
When a macro is created, Excel adds a module to the workbook to store the macro.  When you delete all the macros in the workbook the module does not get deleted.
Note: A macro is a recording of a set of commands. Once a macro is recorded you can simply type the macro's name instead of typing the complicated sequence of commands, and all the commands automatically run that you have recorded.

How to delete the Module:

1. Open the Excel file that no longer contains the macro.
2. Press Alt+F11 (function key at top of keyboard) to display the Visual Basic Editor.
3. Near the upper-left side of the editor is the Project Explorer. This contains a hierarchical tree that shows the workbook name and the different modules in your workbook. If the Project Explorer is not visible on your screen, press Ctrl+R to display it.
4. Within the Project Explorer should be a folder called Modules. If it is not already open, double-click on the Modules folder to display its contents.
5. Right-click on a module in the folder. A menu is displayed. (See picture below.)
6. Choose the Remove option from the menu. You are asked if you want to export the module before removing it.
7. Click on the No button. The module is removed.
8. Repeat  steps 5 through 7 for each module in the Modules folder under your workbook name.
9. Close the Visual Basic Editor.
10. Save your workbook.

At this point your workbook contains no modules, and you will not get any notification when you subsequently open it.

Having difficulty reading the small print on the Internet?

If you are using a mouse with a scroll wheel, you can quickly zoom in on any web page to make it easier to read. 

Here's how:

• While viewing any web page, press and hold the Ctrl key (on your keyboard) while pushing the scroll wheel (on your mouse) away from you.  Pull the wheel towards you to zoom out.

If you don't have a mouse with a scroll wheel, you can use the Zoom option under the View menu of Internet Explorer.

Another helpful hint submitted by Cook Manwiller: use Control and "+", (to increase size)

Control and " - " (to decrease) and Control and " 0 " (zero) (to return to normal size).

Tips for Printing a Web Page

When you print from the Internet you might be surprised at the results -- the page might be cut off on the right or too small to read. Web pages are NOT designed for printing. Some of the newer browsers automatically resolve this problem by shrinking the web page to fit on a standard 8 ½ x 11 page; however this can produce results where the print is very small and difficult to read.


Here are a few tips to improve your print results:

Look on the web page for a “printer-friendly” view and print from that view if it is available.

If a “Printer-friendly” view is NOT available and you are using Internet Explorer (version 7 or 8) to view the web, use the Print Preview option to make changes BEFORE you print. Print Preview allows you to see exactly how the web page(s) will look when printed and the number of pages that will print.

Click File from the menu bar and then click Print Preview. Use the navigation buttons at the bottom of the screen to scroll to view each page that will print.
If the text is difficult to read in Print Preview, change the direction of the paper to “Landscape” using ONE of these methods:
     -- Click the Landscape button on the toolbar

     -- Press ALT+L on the keyboard.

If the Print Preview is acceptable, click the Printer button on the toolbar to print the web page(s).

Having trouble opening Microsoft Word email attachments?

Office 2007 attachments have a different file extension than previous versions of Microsoft Office. (The file extension is the 3 or 4 letters after the file name, for example if the file is called "Test" and it is an older Word document, it would appear as: Test.doc where "doc" is the file extension.) 
Every file extension is associated with a different program so your computer knows what program to use in opening the file.
If you receive an email attachment with an “x” or an “m” at the end of the extension, it is probably a Microsoft Office 2007 file.
Example:


2007 Excel files end with: .xlsx or .xlsm (contains macros)

2007 Word files end with: .docx or .docm (contains macros)

2007 PowerPoint files end with: .pptx or .ppsx



If you are using an earlier version of Microsoft Office (i.e. 2000, 2002, or 2003) you will NOT be able to view Microsoft Office 2007 files, unless your computer has the Compatibility Pack for 2007 Office System (2007 file conversion add-on) downloaded. If you need this 2007 add-on, it can be downloaded from Microsoft.


IMPORTANT: Be sure to install all High-Priority updates from Microsoft Update before downloading the Compatibility Pack.

Computers that already have the Compatibility Pack for 2007 Office System will display it in the Add or Remove Programs under the Control Panel. (See screenshot below.)


To see if the Compatibility Pack is already installed on your computer, do the following:

Windows XP Users:


1. Click Start; Control Panel; Add or Remove Programs.


2. If you have Compatibility Pack for the 2007 Office System displayed in the list, you will be able to open Office 2007 files.

Internet Explorer - Create a Shortcut to a Website

Do you have a website that you like to visit frequently?

Create a shortcut on your desktop to quickly access any website.

Here's how:

1. Open Internet Explorer.


2. View the website for which you want a shortcut.


3. Click "File" from the menu bar and then select "Send" and "Shortcut to desktop".


4. Now close Internet Explorer and you will see a shortcut to the website on your desktop.


5. Double-click on the shortcut to open the website.

Here's an example of a shortcut to "CraigsList" :

Notes:

• You must be connected to the Internet for the shortcut to open a website.


• If the Menu Bar is not showing (version 8), right-click in a blank area of the toolbars and click "Menu Bar" from the list.

Don't Retype...Change Case (Microsoft Word)

Do you know that if you've typed a sentence, paragraph, or entire document in a specific case like ALL CAPS and later want to change it to lower case, Title Case (first letter of each word is capitalized) or Sentence case (first letter of sentence is capitalized), you can easily change the case without retyping!

Microsoft Word 2003 and earlier:

1. Select the text you wish to change.


2. From the menu bar click Format; Change Case.


3. Select the case to use.


4. Click OK.

Microsoft Word 2007:

1. Select the text you wish to change.


2. On the Home tab, in the Font group, click the Change Case button.


3. Select the case to use.

Note: This option is also available in Microsoft Outlook if you are using Word as your email editor.

Microsoft Excel - Easily Switch Between Multiple Worksheets

If you have an Excel workbook that contains many worksheets, you’ll find that switching between sheets can be tiresome. There is only so much room available for Excel to display the worksheet tabs, so you are often forced to scroll between the sheet’s tabs.

To quickly select a worksheet tab that is not within view:

Right-click on the worksheet scroll bars. (See screen shot on left.)
Click on the appropriate worksheet.

Note: If there are too many worksheets to display, “More Sheets…” is listed at the bottom of the menu. To view all sheets, click “More Sheets:“ to bring up the “Activate” dialogue box. Then to activate the sheet you want, simply select it from the list and click OK.