I had to reset my excel on friday now today I'm getting an error when opening up an workbook.
The error is " Cant move focus to the control because it is invisible ,Not enabled or type that does not accept focus.
I have this code in a workbook when the workbook opens
It use to work just fine to the reset of excel. Any idea's on how to correct the problem?
Please Login or Register to view this content.
Thank You, Mike
Last edited by realniceguy5000; 09-28-2009 at 09:40 AM.
I can't see anything in that code to cause the error, is it possible to upload the workbook?
Hope that helps.
RoyUK
--------
For Excel Tips & Solutions, free examples and tutorials why not check out my web site
Free DataBaseForm example
I think I found the problem, I have some code that places the code above in a workbook.So when the user opens it fits there screen correctly.Originally Posted by royUK
At some point this code was placed in my personel macro workbook so when I was trying to open the Other workbook it was trying to switch to my hidden personel macro workbook.
Anyway I removed the code from "thisworkbook" that was in my macro workbook and everything worked like it was suppose to.
Just not sure how that code was placed there.
Anyway it's seems to be working fine now.
Thank You, Mike
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks