Incognitus
09-25-2012, 10:34 AM
Before I begin, I'd like to apologize for not being able to post the Workbook concerned, or post the exact code I've used. Unfortunately, it is stored on a closed internal network without any means of removing it from that network --- and I can't even bring full note in or out of the building. :banghead:
Anyway, I have a spreadsheet which has a modeless Userform (Let's call it "n") popping up after an autoshape is pressed. It has an initialization event that sets it always on top (using a pretty standard "Always on Top" function - I think I got it straight from this site's knowledge base) and then minimizes the application window behind it, thus leaving this form to be the only item on screen. After this, all controlsources for text boxes are set.
When this userform is closed with the X button, the application window maximises.
This worked all fine and dandy up until my last update this afternoon. I added another userform that would appear when a button was pressed on "n" (let's call this one "Y" - y not?). I put in a delay, which resolved the issue I was having with the spreadsheet crashing at this point. At this point, "n" was closed. I then programmically set up "Y"'s textbox control sources.
The issue is not with Y.
Since adding "Y" however, "n" refuses to minimize the application window. Additionally, when I press the original autoshape, I noted that it would do three things - the exact same things each time.
First, nothing would happen.
Second, Form "n" would open, but without minimizing the application window and gaining an always on top property.
Third, the spreadsheet would white out and become unrecoverable.
Each time without fail the same thing happens. I put in a msgbox in various places to find out where the problem might be.
I put one in the call event in the autoshape before and after the request to open the userform: The above three events still happened, except the first time the autoshape was clicked, the msgbox appeared. It never appeared again.
I put it before the API function to make the window always on top - same as above, except the message box appeared the second time only.
I put it after the API function - same thing again, except this time, it didn't show up at all.
:help
I'm at my wit's end. This is supposed to go live as of tomorrow morning, and it all appeared to be working smoothly when I initially tested it. I don't know what could have changed that would have effected this. Even if nobody is able to provide an answer, any suggestions or pointers of things to look at would be a great help.
And again, I am so sorry that I can't provide a workbook, but hopefully the above will be enough to go on.
Thanks very much for even the smallest suggestion!
Anyway, I have a spreadsheet which has a modeless Userform (Let's call it "n") popping up after an autoshape is pressed. It has an initialization event that sets it always on top (using a pretty standard "Always on Top" function - I think I got it straight from this site's knowledge base) and then minimizes the application window behind it, thus leaving this form to be the only item on screen. After this, all controlsources for text boxes are set.
When this userform is closed with the X button, the application window maximises.
This worked all fine and dandy up until my last update this afternoon. I added another userform that would appear when a button was pressed on "n" (let's call this one "Y" - y not?). I put in a delay, which resolved the issue I was having with the spreadsheet crashing at this point. At this point, "n" was closed. I then programmically set up "Y"'s textbox control sources.
The issue is not with Y.
Since adding "Y" however, "n" refuses to minimize the application window. Additionally, when I press the original autoshape, I noted that it would do three things - the exact same things each time.
First, nothing would happen.
Second, Form "n" would open, but without minimizing the application window and gaining an always on top property.
Third, the spreadsheet would white out and become unrecoverable.
Each time without fail the same thing happens. I put in a msgbox in various places to find out where the problem might be.
I put one in the call event in the autoshape before and after the request to open the userform: The above three events still happened, except the first time the autoshape was clicked, the msgbox appeared. It never appeared again.
I put it before the API function to make the window always on top - same as above, except the message box appeared the second time only.
I put it after the API function - same thing again, except this time, it didn't show up at all.
:help
I'm at my wit's end. This is supposed to go live as of tomorrow morning, and it all appeared to be working smoothly when I initially tested it. I don't know what could have changed that would have effected this. Even if nobody is able to provide an answer, any suggestions or pointers of things to look at would be a great help.
And again, I am so sorry that I can't provide a workbook, but hopefully the above will be enough to go on.
Thanks very much for even the smallest suggestion!