Thanks for the info Rob.
I have XL2000, and it didn't work for me. It's about time that Applictaion
had an hWnd property, good to hear that. Are there any others?
Bob
"Rob Bovey" wrote in message
...
"Bob Phillips" wrote in message
...
Michael,
Small error. In Workbook_Deactivate it should be
Hi Bob,
Depends on which versions of Excel you're targeting. The Application
object in Excel 2002 and higher has an Hwnd property, In which case the
FindWindow API call in this example is unnecessary.
--
Rob Bovey, MCSE, MCSD, Excel MVP
Application Professionals
http://www.appspro.com/
* Please post all replies to this newsgroup *
* I delete all unsolicited e-mail responses *