PDA

View Full Version : Accessing a macro in a locked project in another book.



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:

lucas
10-09-2007, 03:30 PM
You should not need access to the vbe to run those macro's. Just because the project is locked doen't mean you can't run the macro's.