View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Chet Shannon Chet Shannon is offline
external usenet poster
 
Posts: 6
Default How mk code applicable to any active workbook?

I created a macro that will create footers for the active
wkbk, but does anyone know how to get a given macro to
run on any workbook that is open and not just the active
workbook? In other words I want this macro to be
executed on any workbooks that happen to be active at the
time. (Rather than be executable soley on one specific
macro.)

Thanks,
Chet