View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
BrianB BrianB is offline
external usenet poster
 
Posts: 1
Default Edit Macro to work for other Workbooks

For this to work you need to have your code included in th
SheetSelectionChange event code of each workbook. ...
Or at least a Run statement there pointing to a macro in anothe
workbook. (See Run Method in VBA Help)

--
Message posted from http://www.ExcelForum.com