closes

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!!

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...

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...

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...

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

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...

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...

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

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...

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...

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...

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...

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...

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?

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...

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