Posted by Jerid on May 18, 2001 12:00 PM
Does anyone have a way to unlock/lock a VBProject through code?
I'm trying to use one excel application to make copies of another excel application, then change one line of code in the copy.
My plans were to Copy the original file, open the copy, unlock the VBProject inside the copy, replace one line of code, and save.
I have it sort of working by using SENDKEY to prompt for the VBProject password dialog box, enter the password, followed by the Enter key twice. But, because I have two differnt workbooks open at the same time (two VBProjects) and I keep switching back between them, my procedure falls apart after the first file when the wrong VBProject gets the send key because I can't find a way to select a VBProject through code.