I have a workbook (wb1) with formulas, that saveas' itself into a new workbook(wb2) with only values. I have alternate macros that I need to run based off each workbook type (formulas vs. values).
I would like to create a mechanism based off of a workbook_open event that looks at the activeworkbook.name. If it's "wb1", then it runs 'x' macro, if it's "wb2" then it runs 'y' macro.
This is probably as clear as mud but any help would be awesome! Thanks in advance.
<strike></strike>
I would like to create a mechanism based off of a workbook_open event that looks at the activeworkbook.name. If it's "wb1", then it runs 'x' macro, if it's "wb2" then it runs 'y' macro.
This is probably as clear as mud but any help would be awesome! Thanks in advance.
