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

Watch MrExcel Video

This Week's Hot Topics

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top