Copy a subroutine to another workbook's VBA project (Excel 97)

[JayGoettelmann]

I've written code to setup a new blank workbook into a specific template. The code also adds a menu to the menu bar. I would like to have menu button states reflect the status of tasks in the new workbook. To do this I hope to copy code from the original VB project (the one that is home to the set-up code) into the new workbook's Activate event. I'm fairly certain I could find this answer in the VB help files, but they are not installed here at work.

 

[VulcanJedi]

I think I have read a lot of people trying to do this? I don't recall ever hearing of any successes?

One creative solution is to save a seperate template and you could make 'invisible' open and save as new sheets/workbooks, but that way code is already within the xl document...

Tranpkp