close

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

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

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

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

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

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

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

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

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?

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

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

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

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

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

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

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

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)?

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

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