worksheet_activate

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

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

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?

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

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

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

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

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

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

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