close

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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