Back

About MrExcel
Consulting Services
Learn Excel Resources
Challenge of the Month
MrExcel Seminars

Message Board

MrExcel Store
Podcast
Search
Contact
Home

 

 
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.

By Juan Pablo Gonzalez on 22-Jan-2002

MrExcel.com Consulting can be hired to implement this concept, or many other cool applications, with your data.

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.

 

Excel is a registered trademark of the Microsoft® Corporation.

All contents Copyright 1998-2008 by MrExcel Consulting.