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.

MrExcel.com provides examples of Visual Basic procedures for illustration only, without warranty either expressed or implied, including but not limited to the implied warranties of merchantability and/or fitness for a particular purpose. The Visual Basic procedures on this web site are provided "as is" and we do not guarantee that they can be used in all situations.