redefining the Edit->Fill->Down shortcut key in Excel 2002 ...

  • Thread starter Thread starter Jerry
  • Start date Start date
J

Jerry

In Excel 2002, the Edit->Fill->Down shortcut key is
CTRL+D. Is there a way to refine the shortcut?

When I press CTRL+D, Excel gives me a "Run-time
error '1004': Method 'Range' of object '_Global' failed"
error.

Any info would be appreciated...
 
Hi Jerry,
In Excel 2002, the Edit->Fill->Down shortcut key is
CTRL+D. Is there a way to refine the shortcut?

When I press CTRL+D, Excel gives me a "Run-time
error '1004': Method 'Range' of object '_Global' failed"
error.

Obviously some add-in or another macro has hijacked the shortcut key.

See if any of these may help you find the cause:

Try opening Excel without any addins or hidden workbooks:

Start, Run,
"C:\Program Files\Microsoft Office\Office\Excel.exe" /Automation

Quotes mandatory, Note you may have to change the path.

If your error disappears, there is either an add-in or a (hidden)
workbook that is loaded upon XL's start, which bothers you.

- Try locating the XLSTART directory, move everything from there.
- In XL: Tools, Addins, note the ones checked and uncheck them one at
the time, each time restarting XL
- In XL, Tools, options, general. Check if a path is entered after
"Alternate startup file location". Clear it.

Now restore the things above one-by-one to find the offending item.

Regards,

Jan Karel Pieterse
Excel MVP
www.jkp-ads.com
 
Back
Top