CNCOldster
New Member
- Joined
- Apr 26, 2013
Folks,
I've joined this forum for a couple reasons.
Foremost is that I don't believe that Microsoft is interested in anything I have to say.
Secondly, I'm using Windows 7 at my office and on my main personal computer and, after getting a new laptop with Windows 8, I realize that I have to make the best of 7 because I will never switch to 8 for any serious work.
Although I like many things in 7, there always seems to be problems with the windows themselves. Not being able to have folder windows remember their size and position continues to haunt me every day.
Also, for my job, I rely heavily on Excel sheets and macros that I've used for quite a few years. When I "upgraded" to Win7, my macro windows started going wonky. I have a dual monitor setup and suddenly my macro windows started opening up on the opposite monitor from where that app was displayed. I had to go in and code EVERY window to open up over the parent app. Nevertheless, that's done now but I have a new problem. I have a couple macros that display information while cycling through sheets and processing data. On XP, these worked beautifully and the window, while it flickered, kept me informed as to where it was. Now the same macro on Win7 freezes after a few seconds. It remains frozen (with a Not Responding tag in the title bar) until the macro ends. Then, most of the time, the window disappears behind the app window. Since it's still the active window, my app is frozen. I've come up with a workaround: I click somewhere on the desktop to de-activate the app, then I click on the sheet to activate it again and my macro userform shows up. Then I can close the userform and continue working on my sheet.
I realize this is a bit verbose but I'm wondering if there's anyone who can help, at least with this macro problem. I've tried various userform settings and none seem to make a difference.
I also realize my problem with windows size/positions is just typical Microsoft "helping" me and I'm just not bright enough to understand their benevolence.
Any advice would be greatly appreciated, whether it works or not.
Thanks,
Rob
I've joined this forum for a couple reasons.
Foremost is that I don't believe that Microsoft is interested in anything I have to say.
Secondly, I'm using Windows 7 at my office and on my main personal computer and, after getting a new laptop with Windows 8, I realize that I have to make the best of 7 because I will never switch to 8 for any serious work.
Although I like many things in 7, there always seems to be problems with the windows themselves. Not being able to have folder windows remember their size and position continues to haunt me every day.
Also, for my job, I rely heavily on Excel sheets and macros that I've used for quite a few years. When I "upgraded" to Win7, my macro windows started going wonky. I have a dual monitor setup and suddenly my macro windows started opening up on the opposite monitor from where that app was displayed. I had to go in and code EVERY window to open up over the parent app. Nevertheless, that's done now but I have a new problem. I have a couple macros that display information while cycling through sheets and processing data. On XP, these worked beautifully and the window, while it flickered, kept me informed as to where it was. Now the same macro on Win7 freezes after a few seconds. It remains frozen (with a Not Responding tag in the title bar) until the macro ends. Then, most of the time, the window disappears behind the app window. Since it's still the active window, my app is frozen. I've come up with a workaround: I click somewhere on the desktop to de-activate the app, then I click on the sheet to activate it again and my macro userform shows up. Then I can close the userform and continue working on my sheet.
I realize this is a bit verbose but I'm wondering if there's anyone who can help, at least with this macro problem. I've tried various userform settings and none seem to make a difference.
I also realize my problem with windows size/positions is just typical Microsoft "helping" me and I'm just not bright enough to understand their benevolence.
Any advice would be greatly appreciated, whether it works or not.
Thanks,
Rob