VBA editor & help

  • Thread starter Thread starter MikeR
  • Start date Start date
M

MikeR

Is there any way to keep the VBA window from re-sizing when help is used? I can start
help, resize the editor, ALT-TAB to help and the editor shrinks again. Excel 2K.

Thanks,
Mike
 
If you are comfortable modifying the system registry with RegEdit
(remember, there are no "undo" or "save without changes" operations
with the registry -- everything is live), you can add a new DWORD
value named "IsFloating" and give it a value of 1. Create this value
in the key:

HKEY_CURRENT_USER\Software\Microsoft\Office\9.0\Common\HelpViewer

Restart Excel after you create the IsFloating value and the Help
window will behave properly.

Cordially,
Chip Pearson
Microsoft MVP
Excel Product Group
Pearson Software Consulting, LLC
www.cpearson.com
The San Diego Project Group, LLC
(email is on the web site)
USA Central Daylight Time (-5:00 GMT)
 
Chip said:
If you are comfortable modifying the system registry with RegEdit
(remember, there are no "undo" or "save without changes" operations
with the registry -- everything is live), you can add a new DWORD
value named "IsFloating" and give it a value of 1. Create this value
in the key:

HKEY_CURRENT_USER\Software\Microsoft\Office\9.0\Common\HelpViewer

Restart Excel after you create the IsFloating value and the Help
window will behave properly.

Cordially,
Chip Pearson
Microsoft MVP
Excel Product Group
Pearson Software Consulting, LLC
www.cpearson.com
The San Diego Project Group, LLC
(email is on the web site)
USA Central Daylight Time (-5:00 GMT)
Click to expand...

Thanks, Chip -
That did it. The key was already there, but the value was 0.
Course you can always export the part of the registry you're tinkering with, which
gives you kind of a safety net.
 
Back
Top