enableevents

  1. D

    Help me understand my VBA code please (easy) - thanks!

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

    VBA one cell returns date of last time another cell was edited

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

    Cancel Change Event When Saving File

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

    ScreenUpdating, EnableEvents settings

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

    Controlling AutoFilter

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

    Application.EnableEvents not working

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

    Removing Multiple Edit Ranges in Worksheet.Activate

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

    Excel 2010 VBA MsgBox 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...
  9. R

    Excel behaves like EnableEvents set False when it is still set True

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

    EnableEvents query

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

    Event Macros Not Being Triggered

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

    Worksheet_Change and EnableEvents

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

    Disable Events not preventing crash....

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

    Excel Automation from Access problem

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

Some videos you may like

This Week's Hot Topics

Top