Not sure what version you have, but for example if you have Office XP goto:
HKEY_CURRENT_USER\Software\Microsoft\Office\10.0\Common\HelpViewer
Add a DWORD value named "IsFloating", and enter a value of 1, and select
hexadecimal. If the "IsFloating" value already exists, then modify it's
value to equal 1. Restart Excel and VBA.