close

Hello everyone! I just purchased Office 2019. In Excel, where did the small "x" go when closing the current workbook. Each time I open an Excel document, it opens another window in Excel. Is there anyway to go back to having the small "x" to close out the current Workbook and not close out the...

I have been using Excel to create a report, that is then pasted into another application. Because of the restrictions of the other application, I need to copy the information from Excel, Paste it into Word, and then copy from Word to paste into the application. (it has to do with merged cells...

Hello, I need help using the conditional formatting colors on Close Date. When Close Date is less than (270 days, 180 days , 120 days, or 60 days) from As of Date from the NAME (e.g., Introduction, Meeting Scheduled, Meeting Confirmed, and Sales closed) I want the close date cell to change...

I have this code in my workbook open and workbook close events. When the workbook opens, the code is to edit the second entry (which it does exactly what it is suppose to do), however, when I close the workbook, instead of editing the second entry, it enters duplicate entries. The code is only...

I try to keep my formulas as simple as possible. Here is my current formula for finding a match in two columns: {=SUM(IF(F$24:F$43=F44,$D$24:$D$43))} The issue with this is that it sums instead of just reporting the value. Which is a problem if the results are not numerical. I tried this...

Hi all, I am trying to close a file using VBA which in itself is quite simple however the file name changes so I only ever know a part of the filename and its location. Location: P:\Public User Area\Purchasing\Suppliers\National Tube Stockholders\Price Review\ The section of the filename that...

Hi, I created a utility for data retrieval/input and it is meant for customer use, therefore I designed it to only show a userform when the workbook is opened, and close the excel application when the userform is terminated. However, this makes it so I now cannot access the Visual Basic editor...

Hi Experts, Could you please help me complete this formula? I am looking up a value in one sheet, and if it is found then display it, if it is not found, then lookup in the second sheet, if it is found display it, and then so on and so forth. The example I have so far is...

Is it possible to display a custom userform message at two different times on the same day using 1) one userfrom 2) not being available to close the earlier form ? The earlier userform time to display blocks the later userform display from displaying. What I want is to be able to show BOTH...

Hello all, I am having an issue with conditional formatting not updating in my cells. It was working this morning and at some point stopped. However, if I save the file, close it, then reopen it, updates show up just fine. But, if I do that and start working in it again, the cells don't update...

I have two userform (Userform A - ShowModal=True & Userform B - ShowModal=False). When I minimize A, B appears. When I close B, A also closes. I want A to remain showing. How can i make B remain open when I close A. (Confused...my apologies)

I have a macro that takes you to the next open line in a series of data. I would like it to follow the current row you are in, so If I am in row 567, I would like the button to be somewhat close to that row. Any ideas?

Any idea why these lines of code would be causing my computer to lag and the excel sheet to freeze when closing the sheet? Private Sub Workbook_BeforeClose(Cancel As Boolean) Dim f As Long Dim j As Integer For f = 1 To Rows.Count If Cells(f, 1).Interior.ColorIndex = 37 Then...

Hello Everyone, What can i do to keep the text in TextBox after i close the workbook? Im preparing a table where one column is describe as "See comment", When i click on on each cell belong on this column: UserForm will be show with the Textbox on it, That was easy to do, But each time when i...

An excel file and folders including folder "Scan" is currently opened. How to close only "Scan" by VBA?

My program opens a spreadsheet. I want to close this one using the x symbol without asking me if I'd like to close all other spreadsheets. I have this written in my ThisWorkbook coding section. Public swb As String Private Sub Workbook_Open() Application.ScreenUpdating = False swb...

Hello all, I've got several query pulling out unique subsets from my main data set. This is all in the same workbook. When I do my PQ, I always close & load to new sheet. But, I want the result to come into the new sheet down a few rows, like maybe in cell D1 or so. This leaves me room for...

So I have a form where its workbook is hidden. The user opens a file which generates a separate open workbook. My problem is when I close this other workbook, excel prompts me to save/unsave my userform too... I've included some code in the ThisWorkbook module that allows me to close a separate...

My User Form opens another excel file. I want to close this newly opened file when I want, but not have excel ask me to close my User Form interface. I have the below code in my ThisWorkbook VBA script window, but it still does not allow me to keep my User Form open after trying to close the...

Morning all, I have an file I open(file defaultsd to cell C2 which Must be filled in.) with a click box in a form. when the workbook opens I can't edit the fields. the cursor is a thin lined cross , when i click it turns to a plus sign then back. when I try to close I get my message to fill in...