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.
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.