Recent content by Neddy

My last shot at solving this one, and you'll need another PC with Word (97 or 2000) on it, as you need to get at the VBA editor. First create a new Template file called FullScreen.DOT (or whatever, as long as it's a .DOT file). Save this to floppy disk. Click on Tools | Macro | Macros, and in...

Sorry, my mistake - ignore last post. Try Alt + V to bring up the Views menu. Then toggle off Full Screen.

You could try hitting Alt + Ctrl & N, which is the default keystroke for Normal View.

Check your Word Startup folder for unwanted templates. In Word, click on Tools | Options | File Locations, select Startup from the list, then click Modify to get the full path of your Startup folder. When you've noted (or copied to the clipboard) the path, hit Cancel (you don't want to modify...

You'll need to do a bit of programming to achieve this. If you want a hand with the actual code, e-mail me, but the basic method is as follows: First you need a userform containing a combo box (actually, a listbox would be OK). In the Form_Initialize event (which runs when the form starts up)...

Could be lots of different things. Check first that your spreadsheet isn't so big it's simply taking forever to print. Second, hit Ctrl + Alt + Del, and select Task Manager, then have a look at things like memory and processor use: if it's hitting the roof it could be that your workstation is...

Alternatively, you can use this macro, which takes the range of cells you've selected, opens a new workbook, pastes the cells into the first sheet, deletes all the rest of the sheets (you can avoid having to use this by ensuring that your workbooks only contain one sheet by default) and then...

Set up your worksheet with the modified colours as a template, and base all new worksheets on that template (put it in XLSTART to bring it up every time you start Excel).

If the drop-down list is a custom VB list box or combo box in your document, then clicking on it is an "event" which can be used to trigger some code which will update your text box. You'd need to go into the Listbox1.Click event subroutine and add code like: For Counter = 0 to...

You need to write a small macro, place a button on the toolbar, then assign the macro to the button. This code works in Excel 2000: With Application If .Calculation = xlCalculationManual Then .Calculation = xlCalculationAutomatic Else .Calculation =...

I had the same problem, which I solved by uninstalling Office 2000, then reinstalling from scratch. There may be a less brute-force method, but this worked.

Yes. First, select the part of your document containing the page breaks you want to get rid of, or Select All, as the case may be. Next, click on EDIT, then REPLACE. In the FIND AND REPLACE dialog box, if there's a button marked MORE, click it to get the full range of options. With...

One other thing you could try: clear out every instance of Word and Excel docs or templates from the C:\WINDOWS\SHELLNEW folder (it's a hidden object, so you might have to unhide it first). One of our departments which runs NT profiles on Win 9x machines recently had a problem with all their...

I assume you're talking about two printer icons on the toolbar in Word, Excel etc. One explanation could be that the user is loading a custom template on startup, in which the toolbar has been messed about to include a stray printer icon. When the user is logged in, launch Word and if you...

Can I just say that I second Dreamboat's suggestion wholeheartedly - I'm always trying to get my users to use the keyboard shortcuts rather than the mouse. There are quite a few keystrokes to learn but once you've mastered them you never go back. And, best of all, you don't have to stop typing...