enableevents

  1. 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...
  2. 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...
  3. 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...
  4. 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...
  5. 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...
  6. 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...
  7. 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...
  8. 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...
  9. 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...
  10. 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...
  11. 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...
  12. 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

  • populate from drop list with multiple tables
    Hi All, i have a drop list that displays data, what i want is when i select one of those from the list to populate text from different tables on...
  • Find list of words from sheet2 in sheet1 before a comma and extract text vba
    Hi Friends, Trying to find the solution on my task. But did not find suitable one to the need. Here is my query and sample file with details...
  • Dynamic Formula entry - VBA code sought
    Hello, really hope one of you experts can help with this - i've spent hours on this and getting no-where. .I have a set of data (more rows than...
  • Listbox Header
    Have a named range called "AccidentsHeader" Within my code I have: [CODE]Private Sub CommandButton1_Click() ListBox1.RowSource =...
  • Complex Heat Map using conditional formatting
    Good day excel world. I have a concern. Below link have a list of countries that carries each country unique data. [URL...
  • Conditional formatting
    Hi good morning, hope you can help me please, I have cells P4:P54 and if this cell is equal to 1 then i want row O to say "Fully Utilised" and to...
Top