How to close a workbook in a subform and return to the main form

Question

0.00/5 (No votes)

See more:

My main form is frmFoodPantry, and it calls a subform called frmOpentotals. The only purpose of frmOpenTotals is to hide all other sheets and display the Totals sheet. This all works fine, but when the user closes the sheet using the 'X' on the spreadsheet, then the frmFoodPantry form opens all greyed out. It runs InitializeComponent(); properly but won't display the form properly.

I can make it work by putting a close button on the frmOpenTotals form, but that is a really ugly bandaid.

I could put it all in one file, which makes it large and hard to follow.

C#

private void frmFoodPantry_Load(object sender, EventArgs e)
 {
     this.Show();
     this.Enabled = true;
 }

In frmOpenTotals

C#

private void app_WorkbookDeactivate(Microsoft.Office.Interop.Excel.Workbook Wb)
  {
      this.Close();
      frmFoodPantry pantryForm = new frmFoodPantry();
      pantryForm.Show();

  }

What I have tried:

app_WorkbookDeactivate
app_WorkbookBeforeClose

Posted 18-Sep-22 14:13pm

PaulaJoannAllen

Updated 18-Sep-22 18:32pm

OriginalGriff

v2

Add a Solution

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

OriginalGriff · Accepted Answer · 2022-09-18T18:32:00

Your code shows that the Load handler displays the form and enables it: which implies that somewhere the form is disabled - which will cause it to be greyed out and be unable to respond to user input.

And you are creating a new instance of your frmFoodPantry when you try to Deactivate the second form. That's not right because that doesn't bring back the existing instance with anything that has been updated since the app started.

I can't tell you exactly what to do - I don't have access to your code - but basically frmOpenTotals shouldn't know that frmFoodPantry even exists, so it certainly shouldn't be trying to create one.

Instead frmFoodPantry should create frmOpenTotals, add a handler to it's FormClosed event, and display it using Show, then call Hide on itself. In the FormClosed event hander you added frmFoodPantry should call Show on itself.
Remove all the code that sets Enabled, and remove all code which tries to access frmFoodPantry inside frmOpenTotals.

That way, the main form hides when the subform is displayed, and reappears when it goes away.