Hi,
I have ole comboboxes on my Excel97 worksheet.
I have a toolbar with buttons that users click. One of these buttons
does a find Range.Find() call. Everything works fine as long as the
user doesn't have their cursor on/in a dropdown when this call is made.
If they do, I get a Run Time Error 1004 - 'Unable to get the Find
property of the Range class.'
I suspect this is by design as I notice when you give an OLE dropdown
the focus, Excel disables many functions in the standard toolbars.
Is there a way to prevent this from happening? Can I detect whether an
OLE object currently has focus?
Thanks in advance,
Michael D.
Bookmarks