Sam, Tried those. Didn't work. But thanks. Did I mention that I hate version 15 (and Windows 8 (this is running on Win 7 by the way)). Already worked through the missing Calendar Control (DOH!! Why did they get rid of that??). Still having issues with the Application.FileSearch "Mr. Bill" really did us a disservice with backward compatibility when it comes to Excel.
I'm seriously considering blowing away all of the newer versions and just having everyone in the office run 2000 to 2003 (it does everything that I need to do). I'm going to keep plugging away for a little while but with the constant compatibility issues I may just give up and "upgrade" everyone to 2000. Thanks, John On Friday, September 6, 2013 11:29:51 PM UTC-4, Sam Mathai Chacko wrote: > > Interesting. I've worked through 8 to 14, never got a chance to work on > 15. Did you try changing the modal property of the userform? Or a line in > the end saying UserForm.activate? > > Sam Mathai Chacko > On Sep 7, 2013 8:01 AM, "John Wilson" <wilso...@gmail.com <javascript:>> > wrote: > >> I'm in the process of upgrading / rewriting a business application in >> Excel that I started years ago. >> It's shared on our network and people with Versions 8 through 15 are >> using it (now you get an >> idea of my headache). >> One issue (actually quite a number but just this one for now) and it >> seems to be version 15 only. >> I have a userform. >> When it opens, 3 other workbooks open, it gets data from them and >> displays it on the userform. >> I leave those files open so that they don't have to be reopened if the >> user changes search criteria >> until the userform is closed (and the 3 files close) >> In version 15, when it's done loading, I'm stuck looking at the last >> Excel file opened and not my UserForm >> on the initial workbook?? >> I've already tried a number of different options without any success. >> Versions 8 thru 14 work fine. >> Any ideas? >> >> Thanks, >> John >> >> -- >> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s >> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ >> https://www.facebook.com/discussexcel >> >> FORUM RULES >> >> 1) Use concise, accurate thread titles. Poor thread titles, like Please >> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice >> will not get quick attention or may not be answered. >> 2) Don't post a question in the thread of another member. >> 3) Don't post questions regarding breaking or bypassing any security >> measure. >> 4) Acknowledge the responses you receive, good or bad. >> 5) Jobs posting is not allowed. >> 6) Sharing copyrighted material and their links is not allowed. >> >> NOTE : Don't ever post confidential data in a workbook. Forum owners and >> members are not responsible for any loss. >> --- >> You received this message because you are subscribed to the Google Groups >> "MS EXCEL AND VBA MACROS" group. >> To unsubscribe from this group and stop receiving emails from it, send an >> email to excel-macros...@googlegroups.com <javascript:>. >> To post to this group, send email to excel-...@googlegroups.com<javascript:> >> . >> Visit this group at http://groups.google.com/group/excel-macros. >> For more options, visit https://groups.google.com/groups/opt_out. >> > -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/groups/opt_out.
