close

  1. C

    file in use

    my excel workbook says it's locked for editing by "userxx" but that user doesn't have it open. is there a way to force the workbook to close using Windows 10 Microsoft office 365
  2. T

    IF 11:00 PM, do nothing. otherwise do this...

    Newb here so bear with me if the answer is obvious! Situation: Working on a real life business situation where we are looking at current store operating hours and deciding if we need to close early if we are doing less than $40 in sales. I can write the formula for that - no problem...
  3. K

    Help with Array that matches 2 dates with their data

    Hi, I have a table with a series of time and dates and their corresponding foreign exchange close price. Column A has the time format of : 2017:11:14-08:00:00 to 2018:11:08-02:00:00 (Approx 6000 rows of data)Column B has the close prices in the format of: 7128.4 (Approx 6000 rows of data)...
  4. P

    Userform close (without button)

    Hello, Is there a way to close the userform from within my VBA code without selecting a button. I want this to happen without human interaction. Thank you
  5. L

    Excel Out of Memory on Closing

    Hi guys, I have a workbook that uses large sets of data ~8000rows and counting, and whenever I close this work book, Excel gives me the "Out of Memory" pop-up, once I click okay it pops up again, and again... The only way to fix it is to close all my workbooks. > I have Formulas that use...
  6. S

    Closing Excel Application VBA

    I can easily close Excel just using an application.quit and I could close the individual workbook with the workbook.close HOWEVER, I'd like for excel to close the current workbook if other workbooks are open and I'd like it to close the entire program if my workbook is the ONLY one open (so it...
  7. C

    Cant run macro on desired sheet

    New to the board and macros. I have a macro I am running from my personal workbook. It runs on whatever workbook / worksheet I focus on. But during the process it creates temporary worksheets and it is doing so in the personal workbook. If the sheet is closed the temps stay in the personal...
  8. A

    Auto Save on Closing Spreadsheet

    Hello all, I have the below code to automatically save my spreadsheetwhen it is closed down so that people can’t close without saving. However, whenit is closed down, the spreadsheet reopens its self automatically. The only wayto close it down is to exit Excel completely and all spread sheets...
  9. P

    How to close userform if another is open

    Hi please could you help me I have 2 userform called userform 1 and userform 2. If someone has userform 1 already open and someone else trys to open userform 2 I want it to automatically close userform 2 with a message to try later. Can you help me please?
  10. C

    Application.EditDirectlyInCell - change back to default on closing workbook

    Hi all I have the following code embedded on opening a workbook to ensure it functions correctly when opened on another users machine. Private Sub Workbook_Open() Application.EditDirectlyInCell = False End Sub Is there anyway to revert back to the previous state of this on closing...
  11. Z

    Run Time Error Method close of object Window Failed

    HI so recently I have this code below which ends my macro. The vba I use below on my computer works fine and closes the active workbook and doesn't save it like its suppose. On another computer it started to break in red below. I can not figure out why I tried everything. I even removed that...
  12. E

    Losing all subsequent tabs in my files....please help!

    I've been working with a lot of data, many tabs, and macros in my excel worksheets, and I've recently lost all of the tabs that were in the sheet except for the first/original tab. This has happened twice on two different worksheets - I save it, close it, and when I reopen it, all the tabs have...
  13. I

    Simplify code before close

    Morning, I assume the code supplied below is what you require ? When i close the sheet i see the below code running & each page is flickered for me to view. Can it be simplified or changed so when i click close it then does its thing without the visual effect that i currently see each time ...
  14. W

    Stuck on open file.

    Here is a bitof my script. It runs once just fine but if i run it a second time before shutting down the workbook I get an error "File already in open" on line 1. Which file and how can i close it? Open "C:\Users\test user\AppData\test.txt" For Input As #1 Do While Not EOF(1)...
  15. W

    Auto Duplicate file

    What I am trying to do is when a workbook is opened check against a list of authorized users before opening. And I go this working already. The next step - if possible - would be if they are not on that list open a copy of the workbook in a state WHERE THEY CAN NOT SAVE OR SAVE AS and close...
  16. K

    VBA for checking to see if fields in a form are not empty when 'close form' button is executed

    my form has 2 command buttons at the bottom. One is named cmdAdd for adding the data to the worksheet, and the other is named cmdClose for unloading it and closing out the form. I want to introduce a "are you sure you want close" msgbox after the cmdClose is clicked and if any of the fields on...
  17. Mazbuka

    Incorrect password input opens new blank workbook

    Hi, Very small issue but it annoys me...if I type a password in correctly, a new book opens, which I then have to close. I can't see anywhere in options to disable this...can it be (disabled)?
  18. B

    Loop through files in directory, open, filter, copy and paste to Book 1, then close and repeat

    Any idea how to put that in code? Any form of example would be helpful. The files are located on my C (local) drive and all have the same name with the exception of a month/year at the end of the file name. The filtering will be done solely for Column A for the keyword "Actual". I want to copy...
  19. D

    VBA close pdf file open by another

    Hi Is there a way to close a specific file that may be opened by one or more users on different computers?

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