N
netloss
I run into problems when I have both the Find box open and a userform
open. Sometimes, if a function called by a button on the userform tries
to open a file, I get the message:
"Runtime Error 4605: The open method or property is not available
because the find or replace dialog box is open."
Why does it matter whether the Find box is open, and is there any way
to close it from code and then reopen it again to avoid this error? Or
is there another way around this problem entirely?
A possibly related problem is that often when using this same userform
with the Find box, all shortcut keys (both custom and built-in) will
suddenly become disabled, and I have to close the application in order
to get them back. What causes this and how do I avoid it?
Thanks for any advice.
open. Sometimes, if a function called by a button on the userform tries
to open a file, I get the message:
"Runtime Error 4605: The open method or property is not available
because the find or replace dialog box is open."
Why does it matter whether the Find box is open, and is there any way
to close it from code and then reopen it again to avoid this error? Or
is there another way around this problem entirely?
A possibly related problem is that often when using this same userform
with the Find box, all shortcut keys (both custom and built-in) will
suddenly become disabled, and I have to close the application in order
to get them back. What causes this and how do I avoid it?
Thanks for any advice.