enableevents

Hello everybody, I am currently managing a stock (inventory management) portfolio in Excel. In this, I have my current inventory quantity in column I and two columns in column J & K which I can use to subtract & add amounts from my quantity, so: Column I = Current quantity Column J = Enter any...

Hello everybody, I currently have the following: Where column: I = quantity J = subtract any number entered from the quantity after which the number entered will be subtracted in column I and disappear in column J so you can enter a new one in the future J = add any number entered from the...

I have a workbook to create a daily dashboard for our group. I have created VBA code that automatically updates a particular cell with the last save date & time when the file is saved. I had the code in the BeforeSave event, but the problem is that if I cancel the save operation the cell date...

If in a single session of Excel, I have two workbooks and in workbook 1 I set ScreenUpdating and EnableEvents to be False, then close it, are the states for workbook2 still set to False? I'd like to test it but I have found that despite setting ScreenUpdating to False, when I check it in the...

I reviewed 15-20 posts and tried a lot of different options, but I'm still having trouble. I'm trying to accomplish two tasks: 1) Turn off Autofilter only if it's on, and 2) Turn AutoFilter on for the specified range in a single worksheet. I only need to manipulate AutoFilter on the sheet...

Hello, I was using the following code successfully to disable the popup box asking if the user would like to overwrite the file of the same name. However, when I changed the Path to a location on a network drive (not only does the macro run painfully slow), the application.enableevents stopped...

Hi. I am using the worksheet open event as the trigger to copy and paste editable ranges from other worksheets into a 'summary sheet' but I do not want users to be able to edit the ranges in the resultant 'summary sheet'. I can get the data okay but the open event seems to be causing looping...

I have a mysterious problem in which a MsgBox infinitely displays after clicking its buttons. What is really strange is that the next portion of code executes, but doesn't exit the If statement. Sub XcaliburCSV() Dim XQNFile, ProcMet, InstMet As String...

I work in a corporate environment using Excel 2003 and 2007. We have developed many spreadsheets that use events to operate correctly - for example, when a dropdown's value is changed then SQL queries are run to repopulate a set of ranges with the correct lookup values. However, after an...

hello, I am trying to write a code that fires when user filters data. I have tried using Workbook_SheetCalculate in the ThisWorkbook module but although I first have Application.EvanbleEvents=False line then macro still fires twice. This is really strange as on many threads I have read this is...

Good Afternoon, In my workbook I have a series of workbook_change events that, until the other day worked beautifully!! Now, the don't seem to be triggered when they should be. I have looked through all my code and removed all instances of Application.EnableEvents = False that could...

Hi all, having trouble with a user interface I'm creating. I have many cells in my UI that need to be changed by the user, but when they change a particular 'trigger' cell I want some formatting done off to the side. The problem is, as I have it currently coded, the formatting occurs whenever...

This was offered as a solution to another's post... http://www.mrexcel.com/forum/showthread.php?t=465898 but I got a bug in it. I've got the following code to save a copy of the current file to another location... (To test this out, I used my Desktop[shared] and My Documents[master] as the two...

Hi Everyone, I am having an issue with Excel automation that doesnt seem to make any sense. There appears to be a difference between early binding the code and late binding the code - and the late binding is behaving strangely. In short I am using automation to open a workbook, check all the...