Subroutine in multiple Workbooks

  • Thread starter Thread starter michael.blaustein
  • Start date Start date
M

michael.blaustein

I have a simple subroutine that does a Find Replace on the first column
of a worksheet. I get workbooks e-mailed to me that I want to run this
subroutine on. Is there anyway to do this other than copy and paste
the code onto each new workbook? Thank you,
Michael
 
Hi Michael

Copy the code in your personal.xls and use activesheet in your code
You can run the macro then in any worksheet that is active

If you need more help post back
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Run subroutines in other workbooks? 4
Call Subroutine in Excel 3
Calling Subroutines from sub-routine 4
temporarily disabling subroutines 1
Calling subroutine defined in another workbook (autostart workbook) 5
Call subroutine from another workbook 2
Help with Calling a subroutine in the ThisWorkbook Class 6
Miscellaneous VBA Questions 4

Back
Top