Re: $$Excel-Macros$$ Activate Particular Window

2013-09-06 Thread John Wilson
Ravi, Screen shot wouldn't do any good. It's not one Excel File, it's a bunch of them (I quoted "3" on my post but it's actually "8" not that it matters). This is an issue with Excel 15 vs earlier versions. It's possible that it might be a "setting" in Excel 15 that's causing my issue. As I ju

Re: $$Excel-Macros$$ Activate Particular Window

2013-09-06 Thread John Wilson
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

RE: $$Excel-Macros$$ Activate Particular Window

2013-09-06 Thread Ravi Kumar
Dear John, Would u share any screen shot or excel file with us. Warm Regards, Ravi Kumar. From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of John Wilson Sent: Saturday, September 07, 2013 8:01 AM To: excel-macros@googlegroups.com Subject:

Re: $$Excel-Macros$$ Activate Particular Window

2013-09-06 Thread Sam Mathai Chacko
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" wrote: > I'm in the process of upgrading / rewriting a busin