closes

  1. B

    Excel closes wrong instance

    Sometimes when I have two excel workbooks open, If I click the cross on one to close it, the wrong workbook closes without saving. This even happens when the excel closed is on a different screen to the one I have closed. Any ideas what could cause this? Many thanks!!
  2. H

    corrupted sheet

    I have a workbook that has become corrupted. Coincidentally :rolleyes: at the precise same moment microsoft decided to remind me to update my payment method. Anyway, I can open the workbook but it closes when I attempt to access my macros. I can (begrudgingly) rebuild my macros but is there...
  3. S

    BeforeClose on a window?

    I have a board display using multiple windows within Excel spread across multiple monitors. During various events windows popup to show other information and when de-activated, the window is closed. This works like a charm until someone closes the window to deactivate it, in which instance the...
  4. W

    Quit current workbook, but not other active workbooks

    Hi. Got a question. I got a timer that counts from 1 min down, then runs a Sub called shutdown. The problem is, when it closes, it leaves a open empty excel program open, not completely shutting it down, i fixed this with the code under, but if i got a other workbook active, it asks that to...
  5. M

    Prompting to save not working

    Hi, In one of my workbooks, if I try to save it after changes, I am not prompted. The workbook just closes. There are no macros in the workbook. How can I turn the prompt back on? I close the workbook and it just closes which is annoying. Thanks
  6. P

    Close Excel Window

    How can I accomplish closing an Excel workbook and it's except window completely. But I don't want it to close the entire application unless it is the only one left open! So in a lot of cases, I have a lot of Excel books open. So using the application (.) Quit command cannot be used because it...
  7. D

    Disable or VBA to prevent 'Want to save your changes' alert, just want to save it without alert

    Hey guys:) I have a script that runs and closes on it's own, the problem is that sometimes i get this alert 'Want to save your changes to '***File***'? Because of this when the script closes on it's own it does not close properly. Is there any way to disable this alert message so that it just...
  8. C

    Visual Basic closes excel when it is opened

    When I open an excel spreadsheet, VB runs and then immediately closes the spreadsheet. I would like to edit the VB in the spreadsheet, but cannot keep it open to do so. Any suggestions? This was created in an *.xls 97 - 2003 worksheet
  9. R

    Closing one workbook

    Hi there, I have a macro that does various things with a pivot table, it then duplicates the file and saves it as something else. I then need to close this duplicated file once it has been saved but when I use activeworkbook.close it closes the active workbook and the original file. I need the...
  10. P

    Shutdown Workbook if used outside Cloud Enivironment

    I've been working on a very useful tool for my team at work. One of my concerns is that I don't want this tool to be shared with competitors, and/or if a current employee leaves, I don't want them taking it with them. We operate in a cloud environment, so my thought was to run a macro upon...
  11. J

    How does VBA finish with ThisWorkbook.Close ?

    I am trying to finish some code by closing the workbook the VBA runs from. Is this possible? When I try to run the code with 1 workbook open, the code loops to PERSONAL.XLSB and gets stuck (code in there is specific to certain other workbooks). I'm aware that ThisWorkbok.Close closes the vba...
  12. C

    Userform that hides excel closes when new excel workbook is closed

    Hi, I have a Userform that hides the excel workbook from which it is generated. This works fine and I use the following code: Private Sub Workbook_Open() Application.Visible = False General.Show End Sub Now, when I hit a commandbutton on my userform that says exit, I wanted excel to stop...
  13. T

    Macro to stop me closing a workbook if F1 is empty?

    Hi Everyone, I need a macro that when I go to close the workbook down it looks at sheet "welcome" cell F1 and if it says "Submitted" then closes but if not brings up a message box saying "Data not sent" "Do You wish to close document?" "Any Changes will be lost" Yes No, if they click yes it...
  14. Dazzawm

    Opening Macro Enabled Workbook

    I have a wb on my desktop which has a code embedded in it. When I double click it it runs a task then closes. How do I get into it to amend some code please?
  15. P

    ActiveWorkbook.Close closes both target book as well as unsaved workbook

    Hi there folks, its been awhile since I posted anything so if I did anything wrong please let me know. Ok to give some background... I have a bunch of code located in an addin which opens whenever I open excel. The addin contains a custom ribbon ui with various buttons doing various things...
  16. J

    Excel 2010 Filter drop down menu closes after 2 seconds for no reason

    Colleagues Excel 2010 - when tries to filter a column once the drop down arrow is pressed and the select filtering menu pops up it almost immediately closes. No VBA on workbook. Excel been uninstalled and reinstalled Any ideas Thanks Guys

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top