HIDDEN WORKBOOK? Excel Workbook Closes after Userform Submits

Hi All,

I have built this elaborate "software" using VBA and have encountered this one nuisance that I don't know how to fix. I have a HomePage userform that is a hub and serves as the gateway to other userforms or to Excel worksheets. After opening Userform1 from the Homepage and submitting it through a command button click, Userform1 does its thing and I return back to the Homepage. WONDERFUL...but when I click on a command button on the userform to go to Excel (which I can see behind the HomePage Userform), THE WORKBOOK DISAPPEARS!!!

I don't know what code to put here because I don't know where the problem is occurring. But, I have checked the "ThisWorkbook" codes, and the commandbutton codes on the Homepage and I don't know if it is because I broke the cardinal rule of "no selects and activates". Nonetheless, here is a sample vba from the Homepage userform to the Excel sheet.

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Can someone tell me what I may have typed and where it could be so I can delete it?

Thanks!

Hi and welcome.

I think this would be a little easier to diagnose if we could see it in context.

Would it be possible for you to attach your workbook? Desentize the data if necessary.

BSB

Hi BSB,

I can't attach it. It is too large and I'm not sure what to delete to make it attachable but still function. Is there a way that I can send it to you alternatively?


Thanks,
Marsha

Also, how do I make the excel program work without the VBA center operating and available? For example, every time I open the program, the VBA center opens too. On another computer that does not have the developer tab or anything, it will still open if there is a bug in the code. And, to the problem that I posted about, it makes it impossible for the user to continue using it when there is nothing on the screen but Excel says the "reopening the workbook will lose any changes".

It makes it really scary for the user.

If by the "VBA Center" you mean the VB Editor then it is part and parcel of Excel and you cannot separate the two.

If the code in the tool you've built is bug free and error handled appropriately then the end user should never see the VBE.

BSB