MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Keep Excel Window in Focus


January 22, 2002 - by Juan Pablo Gonzalez

Here's a helpful tip for VBA programmers using Office 2000 or XP.

Jose Luis asks:

When I call Help without using the assistant (F1) Excel resizes itself to allow the Help window and the spreadsheet to be visible at the same time.

Is there anything I can do to prevent this? I want Excel to stay maximized and so the help file.

To modify this behavior there's one change that needs to be made to the Registry.

Warning

It's very important to make a backup of the registry before atemping any changes to it. If you don't know how to do this, don't try this tip. MrExcel.com will not be held responsible for any consequences as a result of this change.

Enter Regedit, and look for the key HKEY_CURRENT_USER\Software\Microsoft\Office\9.0\Common\HelpViewer in Office 2000 or HKEY_CURRENT_USER\Software\Microsoft\Office\10.0\Common\HelpViewer in Office XP.

If there isn't a variable called 'IsFloating', it needs to be created (It's a DWORD) and assign it a value of 1.