Internet Fixes Weekly Office XP Newsletter!

It's not hard to assign a keyboard shortcut to any Word menu command. Select Customize from the Tools menu and click on the Keyboard button at the bottom. Select View in the Categories box and ViewTaskPane in the Commands box. Click inside the Press new shortcut key box and press the shortcut you want to use, such as Ctrl-Shift-V. You should see Currently assigned to: [unassigned] below the box. If not, choose another key combination to avoid overwriting an existing keyboard shortcut. Click on Assign, then Close, then Close again. Now pressing your selected key combination toggles the task pane on and off.

Excel isn't as friendly to keyboard shortcuts; in fact, you'll have to create a simple macro. First, close the task pane if it's open. Select Tools | Macro | Record New Macro. For consistency, name the macro ViewTaskPane. Click in the Shortcut key box and press the letter key you want; you can only use Ctrl-letter and Ctrl-Shift-letter shortcuts. Save the macro in the Personal Macro Workbook, so it is always available. Click on OK. Choose Task Pane from the View menu to display the task pane. Now select Tools | Macro | Stop Recording. When you press the keyboard shortcut you specified, the task pane opens.

Ah, but you want to toggle the task pane's visibility with a keystroke, not just make it visible. Select Unhide from the Window menu to make the Personal Macro Workbook accessible. Select Tools | Macro | Macros from the menu, click on the ViewTaskPane macro you created, and click on the Edit button. You'll see that the active line of the macro is Application.CommandBars ("Task Pane") .Visible = True. Use copy and paste to edit this to:

Application.CommandBars("Task Pane").Visible = Not_
Application.CommandBars("Task Pane").Visible

Select Close and Return to Microsoft Excel from the File menu. Now your keystroke will toggle the task pane's visibility.

Simplify summary formulas with 3-D range references in Excel 97-2000-2001-2002

It's common to set up workbooks so that data is logically split
across several sheets. For example, you may dedicate worksheets
to individual months or quarters. When you use this organization
technique, you often also create a summary sheet that
consolidates the information. If so, you may wind up creating a
lot of long, cumbersome formulas, such as:

=SUM(January!D38+February!D38+March!D38+April!D38+May!D38+June!D38+July!D38+August!D38+September!D38+October!D38+November!D38+December!D38)

There's a much more elegant way to create such a summary--use a
3-D range reference. With 3-D references, the worksheets form the
third "dimension" of the reference. When you create the
reference, the first element is the range of worksheet names. You
simply specify the first and last worksheet, separated by a colon.

For instance, the previously shown formula can be rewritten as:

=SUM(January:December!D38)

to achieve the same result

New Help Service!! This Is Used By Companies To Repair Problems Remotely.

Adjust your startup options in Access 2002

If you want to control what happens when you open a database, you'll want to examine the Startup Property dialog box. Some of the more popular options are the Application Title, Application Icon, Display Form/Page, and Display Database Window settings. The Application Title feature allows you to change the text on the Access Window's title bar from Microsoft Access to a name that best suits your database. This name also appears as the button caption on the Window's Taskbar. The Application Icon property can either be a bitmap (.bmp) or icon file (.ico) and will be displayed next to the Application Title on the title bar and taskbar button. Perhaps even more useful is the Display Form/Page setting. Clicking the dropdown arrow on this field displays a list of available forms and data access pages in your database. When it starts the database, Access automatically displays the form or page you selected. Finally, the Display Database Window check box determines if the Database window is visible when the database opens. Even when this option is turned off, however, the Database window can still be accessed by normal means, such as by pressing [F11] or by choosing Window | Unhide and selecting the database window.

To access the Startup Property dialog box, from the Database window, choose Tools/Startup... from the menu bar.

New Help Service!!

There is no reason that It can’t be used for Home User’s. We can offer PcAnywhere connections right now if you have PcAnywhere Installed.

If you don’t have PcAnywhere don’t buy it because Our Home User’s don’t have that many problems that require Remote Help.

If you are using Windows XP you don’t need any other Software to carry out a remote session. I can teach you how to set up with a Remote Session with us!

If you don’t have Windows XP there is VNC Freeware that you can set up to allow a Remote Session with us.

I will be setting up the Directions for using any of the above software for Remote Sessions with us in the coming Weeks.

E-mail:

info@internetfixes.com

We’re on the Web!

www.internetfixes.com

Other Points Of Interest!

Internet Fixes Customer Support!

Windows Registry Tips!

Learn How To Backup The Registry!

Batch File Tips And Tricks!

DOS Command Index!

When Requesting Help On A Computer Related Problem Add As Much Information As You Can For The Hardware and/or

Software!

Just Click Here and then Copy and Paste the following text into the Email that Pops Up. After you have pasted the following text into your Email Program try and fill in as much information that you can. Send it off to me and I will get back to you as soon as possible will an answer to your question!! If you like using an Online Form just Click Here

Need Help!

Computer manufacturer ("Custom Built", or brand name: Dell, HP, etc.) :

Computer model (if brand name) :

Operating system (Windows version) : 95__ 98__ 98SE__

ME__ NT__ 2000__ XP Home__ XP Pro__ Other__

(put an X beside the one that applies)

Type of browser (Internet Explorer or similar) and version :

Motherboard if known :

CPU (processor) type and speed :

Amount of memory installed (RAM) :

Hard drive size:

Hard drive free space :

Sound card ("Onboard", or type of card) :

Video adapter ("Onboard", or type of card) :

Anti-virus program :

Firewall program :

Spyware / Adware check program :

Outline your problem :

Exact error message (if applicable) :

What you were doing when the problem first appeared :

Any new software or hardware installed recently :

Any other information that you think might help :

New Windows XP Tips!

1. 20 Tips Starting With MANAGE AND DEBUG SERVICES USING SC.EXE

2. 20 Tips Starting With EFS best practices

3. 20 Tips Starting With Watch Your Start Menu Folders Grow In XP

4. 20 Tips Starting With Troubleshoot configuration issues with the useful msconfig utility

5. 20 Tips Starting With Save Remote Desktop Connection Settings

6. 20 Tips Starting With Disable Simple File Sharing or join the computer to a domain