Dr Hu

Is there any way to change the colour of the navigation box in Excel?

I have a user with a worksheet that a lot of cells have borders, so when the navigation box is in a bordered cell he can't see it and he gets lost in his worksheet.

Changing the default colour of the navigation box to red for example would fix this problem, had a quick look through the options and can't see anything obvious........

Thanks In Advance......

n.b Excel 2000

DJ Dunk

iTrader: (5)

Excel uses Windows colours for several of its elements. You can change these colors for Excel by changing the Windows colors.

1. Click Start, point to Settings, and then click Control Panel.

2. Double-click the Display icon in Control Panel, click the Appearance tab, and click the element you want to change in the Item box.

3. You can then click the colour and font color you want for each item:

Selected Items Sets the colour of the highlighting Excel uses to indicate which cells are selected. This highlighting is a muted version of the colour you specify.

Dr Hu

yes - that works for the selected box, ie if you drag a few cells it turns pink (if set to red), but the active cell surround box is still black.......????

Any more ideas......

velohead66

Thinking Laterally....

Rather then keep borders = black, and active cell navigation = red,
why not make borders = red, and active cell navigation = black.

This would take 1 min, irrespective of the number of individual borders used.
Tip - Tools, Options, View, Colour .........

Also, if you print in B&W, no problem.
If you print in colour, Mmmm.

Any Help ??