May 08, 2012 Suddenly I can't view my VBA source. The workbook is not protected. Excel 2007 'Project Locked' 'Project is. Not locked, not password protected. May 07, 2012 Suddenly I can't view my VBA source. The workbook is not protected. Password protected.

Hi Harry, Unfortunately, VBA does not expose the VBProject passwords in its object model. Consequently, the only way to achieve what you want is via a workaround. The usual approach is to use SendKeys to simulate the keystrokes that would be used to enter the password for the project. You should be aware, however, that this approach is NOT particularly reliable and I certainly wouldn't want to risk its use in a product that I was distributing (which is, I seem to recall, what you intend to do). Here is an example of code that I picked up somewhere (originally written by Bill Manville). Hi Harry, As Richie(UK) has pointed out the only way is with SendKeys. Download Cooking Master Boy Episode 53 Sub Indonesia on this page.

An accident just waiting to happen, IMHO. That said, I have been playing with a set of SendKey commands and although it will unlock the project I don't think you can Lock it again without closing the workbook completely. I could be wrong. So even if you could reliably unlock and remove a line of code you would have to close the workbook. Therefore killing any upgrade process you were running in mid-stride. Not too smart for the user. As a suggestion for an alternative approach; how about using a property within the workbook that you can store this code in.

• A hidden named range • Custom document property • VBA Projects Description • Entry in the user registry The reduced functionallity would have IF THEN conditional tests around it. No activation code no execution. Harry I would say no I do not recommend this send keys are dreadful and can be a bad friend at best of time, not downing Richie(uk) codes but Richie did say at your own risk I say don’t bother locking codes, I can open then anyway, and many guys I know can, but as Dennis says unless you know how to bust these types of things, the rest of the guys will be glue less and Dennis’ comments is spot on most don’t even know of the VBE. My head cheese at work told me I had written a VLOOKUP wrong?? And they are to dog??? I would not bother to much – its not so good – but to answer your question not if its locked you can not.