worksheet_activate

  1. J

    Compile Error - Unusual

    Hi all. I recently made an excel VBA project which then turned out to be a huge application. This application is being saved in a network shared folder where multiple users are able to access the file (only one at a time though). So, this application runs smoothly thus far on multiple machine...
  2. J

    Pastespecial Triggering Worksheet_Activate to run

    Greetings, When running the code below in a new workbook, with Sheet1 activated and with application.enableevents=True, the PasteSpecial line causes the Sheet1 and Sheet2 Worksheet_Activate codes to run (as well as their respective Worksheet_Deactivate events. Moreover, when the pastespecial...
  3. W

    Run maco on loosiong focus

    I am running code when a worksheet comes into focus using Private Sub Worksheet_Activate(). How can I run a code when the worksheet looses focus?
  4. A

    1004 - Method 'Range' of object '_Worksheet' failed...

    Greetings! Excel 2010 (14.0.7190.5000) 64-bit Win 8.1 Pro I'm getting a 1004 error, "Method 'Range' of object '_Worksheet' failed", when I try to access a WORKBOOK-scope defined-name from a sheet's Worksheet_Activate() routine. Here's the code for the sheet... Private Sub Worksheet_Activate()...
  5. A

    1004 - Method 'Range' of object '_Worksheet' failed...

    Greetings! Excel 2010 (14.0.7190.5000) 64-bit Win 8.1 Pro I'm getting a 1004 error, "Method 'Range' of object '_Worksheet' failed", when I try to access a WORKBOOK-scope defined-name from a sheet's Worksheet_Activate() routine. Here's the code for the sheet... Private Sub...
  6. 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...
  7. P

    Dynamic chart ranges populated from named ranges as selected in nested indirectly sourced validation lists.

    Hi all, Long time reader - first time poster. As the rather cryptic subject says, I'm trying to dynamically populate ranges to facilitate dynamic charts being generated. I use excel 2010 at work, and 2011 for mac at home. I have an example spreadsheet, but I don't know if I can upload it...
  8. R

    How to differentiate when a sheet is selected manually or via VBA

    I have a sheet ("SheetName") which contains a warning pop-up when it is selected manually, using the code below: Private sub Worksheet_Activate() If Msgbox("warning text",vbOkOnly)=7 then end if End Sub which works fine when the sheet is selected. However, I also have another macro which...
  9. D

    Running Worksheet_Activate macro from another macro

    In a worksheet titled "Monthly", I have written a Worksheet_Activate macro which reviews the value of cell A5 to determine whether to lock (protect the contents) of cell B5. When I click on the Monthly tab, I have confirmed that the Worksheet_Activate macro operates as expected. If I change to...
  10. A

    How to change a Label.Caption with Worksheet_Activate

    I'm having difficulty getting my Worksheet_Activate to change my Label.Caption when the worksheet is activated and need some help. I'm using two worksheets. One with DATA in Cells and Command Button. The second sheet is a form that takes the data and put it into Labels, then prints out the...

Some videos you may like

This Week's Hot Topics

Top