goofy78270
10-09-2007, 03:00 PM
I have found numerous post about trying to lock a project, but I am looking for code to call a macro inside a locked project within another book.:banghead:
Book 1 combines worksheets from three different books for different departments. The macro within book 1 copies the sheets from the other three books into itself after running a "sort and manipulate" routine contained within the other three books.
I have tried recording a macro to track my steps but it does not track the steps through VBE.
Can someone point me in the right direction as to how to get this done.:doh:
Book 1 combines worksheets from three different books for different departments. The macro within book 1 copies the sheets from the other three books into itself after running a "sort and manipulate" routine contained within the other three books.
I have tried recording a macro to track my steps but it does not track the steps through VBE.
Can someone point me in the right direction as to how to get this done.:doh: