close

  1. NewOrderFac33

    Keyboard shortcuts not working

    Good morning, - as a Lotus 123 veteran (!) I still use a lot of keyboard shortcuts within Excel such as Alt+f (File) followed by c to close the active workbook. Whilst these work most of the time, sometimes they don't and the above sequence will result in a "c" appearing in the active cell, and...
  2. D

    Can you open an external wb, retrieve a drop down menu then close it

    I have a wb with a drop down menu that correctly references an external wb to get the list but the external wb needs to be open to do so. It is going to be used by more than one person and will be stored on a server. Is there a way to have the external wb open when the cell with the list is...
  3. M

    Resource booking template

    Hi, I'm looking to have 1 sheet that has a list of resources that can be booked. On that sheet if you choose a date and time it shows which resources are free on that date and which are not. If you then want to book one of them, you enter say a "Y" and it then pulls through to a calendar style...
  4. R

    IF function with multiple logic?

    Hi all, I'm not sure if what I'm trying to do is possible, and if it is, how to go about it :confused: I'm using Excel for a Sales Forecast - the data is extracted from a CRM and copied into my workbook - like the below table (first 3 columns only): <tbody> Est. Closing Date Weighted Total...
  5. D

    Strange "Out of Memory Error" on Close

    I have two files open. Both are pretty complicated with lot's of graphs, Shapes, pictures and formulas. File2 is the Active Workbook. When I simply Save File 2 from the "File" tab - No problem Then, I have a "Button" on File2, that calls a macro in File1, simply: Sub CloseFile2()...
  6. I

    Userform opens twice

    Morning, Please could you check my code & advise a fix. I open my workbook. It defaults to INCOME (1) to open first. I see the msgbox asking me to select MONTH & YEAR I choose to select CLOSE FORM The form quickly coses then reopens. I choose to select CLOSE FORM again & it closes. Now i can do...
  7. C

    VBA If Statement Evaluating After True

    Hello: My workbook has 2 sheets, "Numbers" and "General". I have an If statement that runs at workbook close. If Sheets("Numbers").Range("BA2") = 0 Then Sheets("Numbers").Range("BA3") = "Correct" ElseIf Sheets("Numbers").Range("BA2") <> 0 Then...
  8. gheyman

    Access: Close a Form that is not the Active form

    Can you close one form from another? I know you can close the form you're on by using DoCmd.Close , "". How do I close another form. I need to make sure its not open when I run code. Thanks
  9. L

    workbooks.close

    Hi I am trying to use workbooks.close (the close function of the collection workbooks). So I wrote the code below. but that code will close the workbook i am working on. I wonder if I can close other workbooks but not the one I am on right now using workbooks (collection)? I know I can close...
  10. D

    Close Active window triggers before close event

    I have an excel workbook with 2 views open (View/New Window). When I close the second window (the workbook remains open) it triggers the before close event. Is there anyway of closing the second window with triggering the before close event? I only want the before close event to trigger whe the...
  11. I

    Open userform when worksheet opens

    Morning, My goal is when i open the workbook i should see INCOME (1) open & either show the userform or not depending on cell value in B1 What i see happening is if i was last on worksheet INCOME (3) then i save & close the workbook when i next open it the code runs BUT when i close the...
  12. AccessShell

    Code behind excel form help

    NOTE: Originally posed elsewhere. I do not believe I will get an answer. I hope I can post it here. I have written some code in Sub Workbook_Open. It works fine. However, I am trying to do two more things. 1. I don't know if I should use Workbook_BeforeClose, Workbook_Deactivate, or...
  13. M

    VBA - run code on close of all workbooks (PERSONAL.xlsb code)

    Is it possible to create a code in the Personal.xlsb file that runs when ever you close excel? almost like the save message on close of excel? I want to run a code that disables an addin everytime excel is closed. please help
  14. D

    Close all ComboBox dropdowns when I click a button.

    Hi, I have a sheet that contains several ComboBoxes embedded directly into the sheet. I have them set up so that when I GotFocus the ComboBox dropdown opens (.DropDown method). However, what I would like to do is clear the ComboBoxes and close the ComboBox drop downs when I click on a button...
  15. D

    Prompt for number of copies to print out

    I read several threads here and they seemed really close to what I need but not quite close enough. I have the following existing code that prompts the user to answer Yes or No when asked if they need to print the NMR form. I would like to add code if they say Yes, it asks how many copies are...
  16. M

    Application Quit closing down all instances of Excel

    I've been fighting with application.quit for a while now because it wouldn't close excel. I had this in the open even and first check to see if the user had read write privileges to a folder they will need for everything to work. I got that squared away by putting and Exit Sub after the...
  17. P

    VBA - I dont want the destination workbook to be visible when opening to copy pasting

    Hi, I have a project where I am copying data from one workbook to another using VBA. The syntax has data copying from one workbook, opening another workbook, pasting, then save, and close. The thing is that the other workbook is visible when it opens, and saves then closes. I want it to be...
  18. S

    Excel 2019

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

    Using Excel to close the correct word document

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

    How to use conditional formula to change color when a field is less than other and contains Name

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

Some videos you may like

This Week's Hot Topics

  • Get External Data (long shot question!)
    This is likely a long shot but I am wondering if it is at all possible for Excel to somehow 'change' the contents of a URL that is being linked to...
  • Importing multiple excel files into one spreadsheet
    Hi, I'm trying to import multiple excel files (with the same format into a single spreadsheet) so that each day's file is listed underneath the...
  • Cell Formatting
    Good Morning, I need to format a few different cells in the following manners: A1 has to always add a colon (:) after whatever is typed in by a...
  • How to copy multiple rows using If
    Hi all, I'm very new to VBA and have written this simple code to copy certain cells if a certain cell within that row contains any data. I need...
  • Workbook_Change stopped working !
    I am working on an app to speed up & automate processing of Credit Cards statements. After data is input from a CSV file, it is presented to the...
  • VBA If statement
    Dear All, I have two dates, where I'd like a message box to pop, if the dates are between this criteria. [CODE] sDate1 = #10/1/2019#...
Top