Code to Mimic On Activate

[AllisterB]

Hi
I need some Code that will mimic what happens when you click on the tab for another sheet and back to the original Sheet. I need this to Trigger the On Activate Code of the first sheet.

I recorded the following but it does trigger the On Activate.

Does anyone have any ideas ?

Thanks

Allister

Please Login or Register  to view this content.

[maniacb]

Try

Please Login or Register  to view this content.

[rorya]

If you mean that you want to trigger the worksheet_activate event for that sheet, then you should probably move the code out of that event into a separate routine in a new module, and call that from the Activate event and this macro. You can use Application.Run to call the event code directly but you shouldn't really need to.

[AllisterB]

Hi
When I ran the suggested Code as a separate Macro with a Line of Code Debug.print ActiveSheet.Name between each Line of Code got the following output

Macro Code

Please Login or Register  to view this content.

When Starting the Macro from the PayrollCalc Sheet:
PayrollCalc
PayrollCalc
PayrollCalc
PayrollCalc


When Starting eth Macro from the Summary PayrollCalc Sheet :
Summary PayrollCalc
Summary PayrollCalc
Summary PayrollCalc
PayrollCalc

How does the code need to be changed?

Thanks

Allister
@Maniacb