Excel “Blue Bar” problem / Excel “blanked window” problem
A really annoying problem that sometimes occurs after running a macro is that the left hand side of the Excel window goes blue (the same colour as the border ?)
I found nothing that would kelp until I came across this:
http://support.microsoft.com/kb/905208, it’s for Excel 2002, but I tried it in Excel 2003 and it works. Better , I haven’t found a down side yet. I’ve had it installed since the end of June 2011, and am now preparing to roll it out. Here are the updated command to make it apply to Excel 2003
- Exit Excel 2003.
- Click Start, click Run, type regedit, and then click OK.
- Locate and then click the following registry subkey:
HKEY_CURRENT_USER\Software\Microsoft\Office\Excel\11.0\Options
- After you select the subkey that is specified in step 3, point to New on the Edit menu, and then click DWORD Value.
- Type DisableToolbarRedrawToggle, and then press ENTER.
- Right-click DisableToolbarRedrawToggle, and then click Modify.
- In the Value data box, type 1, and then click OK.
- On the File menu, click Exit to quit Registry Editor.
Becareful editing the registry, but you know that don’t you.
Advertisement
