worksheet activate event

  1. dss28

    Worksheet.change vs. worksheet.calculate event

    I want to add code to some columns in a sheet to define the number format or date format using the following codes ThisWorkbook.Sheets("Report").Range("E2:E" & Cells(Rows.Count, 1).End(xlUp).row).NumberFormat = "mm-dd-yyyy" ' date format ThisWorkbook.Sheets("Report").Range("J2:J" &...
  2. J

    VBA worksheet change event to launch macro??

    Hi, I am need my macro SORT_SAP1 to launch if cell "P12" changes. Can some one help me with the correct syntax for the worksheet change event? Thank you!
  3. M

    Excel 2010 - ActiveX ComboBox Placed On All Worksheets With Dropdown Listing All Worksheets From Formula Generated List

    Hi! I haven't been able to find an answer on this and my issue could be piecing together code I found on multiple forums. This worked fine with the first combo box I tried but I am unable to get this to work on subsequent worksheets. My goal is to have an ActiveX ComboBox drop down...
  4. S

    Trying to lock cells in one worksheet depending on value in another worksheet cell

    Hello, Any ideas as to why this will not run. I've been playing with it all day and can't figure out why it stops after the If statement is evaluated. I'd bet money it's something minute I'm overlooking but I can't find it. I have changed everything I can think of in the two statements...
  5. S

    Macro triggered by Worksheet Activate - endless loop

    I have a multi-sheet workbook. The first sheet is a summary of results from the rest of the workbook. I would like this summary sheet to auto-refresh itself each time the sheet is activated. The VBA code triggered by the Worksheet/Activate event feeds some parameters out to other sheets, then...
  6. S

    Call Worksheet_Activate Event from procedure possible?

    Hi guys, is it possible to call a Worksheet's activate event from a procedure? Or maybe, refresh a worksheet from a procedure. i'm using excel 2003. Thanks Shie Boon

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
Back
Top