Running a macro in one worksheet on another.

Posted by Tore on September 17, 2001 2:35 PM

I've made a VBA-app/macro that takes a listing of video clips with start and end points, and writes this (with description and reel-information) to a tab-delimited file that can be imported into Final Cut Pro. However, since cataloging clips are often spread out to many people, we want the macro to reside in a file that can be shared, and process multiple spreadsheet without having to be copied to each spreadsheet.

Any suggestions?

Thanks,
Tore

Posted by Damon Ostrander on September 17, 2001 3:52 PM

Hi Tore,

If you want to run a macro on multiple sheets in a workbook, or even any open workbook, put it into a macro module rather than in the worksheet's event code area (which is where you are apparently putting it now). Going further, if you want to be able to run the code on other workbooks without always having to open the workbook that contains the code, make it an add-in. It will still have to load in Excel, but it will be almost invisible and painless.

Happy computing.

Damon