before close

Hi, Actually I'm trying to initialize my workbook before closing it (by deleting all the added data) save it then close it. Before that I want to check if there is any data on a specific sheet before deleting and closing the workbook, so if there is any data on that particular sheet so i can...

I have This in My ThisWorkbook Option Explicit Private Sub Workbook_BeforeClose(Cancel As Boolean) With ThisWorkbook.Worksheets("My_Subs") Application.Run "CommandButton2_Click" End With End Sub Private Sub Workbook_Open() Application.OnTime Now + TimeValue("00:00:30"), "Save1" End Sub And...

Hi, How can I edit this code to repeat the check on the next row? I would like the code to check ranges B3:B9, B12:B18, B21:B27, B30:B36, L3:L9 before closing to ensure that the user cannot close the form before editing all cells. I should note that usually only one row will be completed at...

Hello good people, I had a problem that I found the answer for, but it says "This code needs to be posted in a class module and an instance of the class needs to be created before it will work". I am very familiar with "Modules" but never used Class Modules before, and can't seem to be able to...

I was looking for a solution to force users to fill in certain fields on a macros enabled excel, and today i've found this solution that worked as a charm, the only issue is that I as the autor need to close the file with the blank fields so it gets to the user ready to fill in, and this macros...

I use Excel 2010 64 bit W7, although I doubt that is important here. All the message boards say that a save by VBA should trigger a Before_Save event macro in the workbook being saved. It does not for me. I remember reading in an MSDN document on a related issue the offhand comment that Oh, by...

Hi all, Thank you in advance for your help. I'm okay with VBA but I always get a bit confused with these message boxes when they link. So what I want to do is to have a message box that pops up when this Excel file is attempted to close that says "Have you uploaded the data?" "Yes" or "No"...

I have A11:G11 summed in cell H11. If H11 equals 0 (zero), I would like a message to pop up "You must select at least ONE location." I would like this message to pop up before close/save of the file. running excel 2007