running macros

[Manbees]

Hi


I need to create a macro that when you get redirected from the form to a different workbook, that when you close that workbook and go back to the original workbook that the form runs automatically

p.s. the original workbook does not close, it stays open

I'd appreciate any help thanks

[Bob Phillips]

How does this bit happen ... when you get redirected from the form to a different workbook?

If you are activating the other workbook, don't activate it.

[Manbees]

Hey man,

sorry dude, I think I worded it wrong....

The form redirects after the user chooses an option to go to the specific workbook. The form works almost like a database.

How do you code a macro to open the form again when the original workbook is tabbed again.

Is it possible?

thanks man