View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Sergiy Sergiy is offline
external usenet poster
 
Posts: 16
Default How to run macro from Add-In when Excel opened workbook?

Dear colleagues,

Please advise with the subject issue. Here are details.

I need to run a certain macro with any user created workbooks. At the
beginning I've used a Workbook_Open sub and copied my macro to all
workbooks. With this I'am having a lot of limitations and
inconveniences.

I want to move my code inside the Add-In and run it with any workbooks
user created.

Please advise how to get known using Add-Ins macro that user opened a
workbook without adding even a single line of code inside user created
workbooks?

Thank you.

Sergey.