1. fnijkampnl

    properties of tab greyed out when closing

    Hi, I didn't do a search for this problem because I do not know how to make a correct search argument. That is all answers were about something else. This is the case. In my BeforeClose procedure I did a VeryHidden on all tabs and a show on a tab with a warning. The warning stated that the...
  2. D

    Run VBA Code When 'Checking-In'

    Hey guys, I am working on a workbook that is connected to a server. (The Check-In and Check-Out features are enabled) Is there a way to run a few macros in the event that someone checks the file back in? Initially I was using something like this to run some routines when the workbook was...
  3. M

    Close just one Userform with X

    Dear All, I have a userform with a button that opens another userform. Once the user has finished to use the second userform, he is supposed to close it with the X at the top right. This unfortunately closes also the first userform. The first one should remain open and the user should be abele...
  4. 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...
  5. 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...
  6. 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...
  7. 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...
  8. 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()...
  9. 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...
  10. 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...
  11. 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
  12. L


    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...
  13. 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...
  14. 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...
  15. 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...
  16. 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
  17. 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...
  18. 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...
  19. 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...
  20. 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...

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