See www.cpearson.com/Excel/VBE.htm for example code that you can adapt to
your purposes.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting
www.cpearson.com
(email on the web site)

"Shapirotwin1" wrote in message
...
there is a visual basic macro I need to updated in a workbook. There are
well over 100 workbooks that need this update. There are also many
changes
to the worksheets in the workbooks. I have written several procedures
that
update the worksheet data in an separate workbook that automatically runs
when opened, but I don't know how, within this macro, to execute getting
to
visual basic and editing the macro that needs to be updated. Can anyone
point me in the right direction?