One line of code messed up!

[scrabtree23]

I have one line in one module of an Excel VBA code messed
up. I need to write another VBA code that will open the
VBA attached to an excel file, open the VBA password, go
to that module and alter the one line...HELP

 

[ianripping]

might help if you post the code

 

[Bob Phillips]

Why can't you just open it as normal, go to the VB IDE and change it?

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

 

[Tom Ogilvy]

Reread the original question.

 

[Tom Ogilvy]

VBA password is not exposed as an object.

Only solutions I have seen offered for this involve the use of sendkeys.

You can search the google groups archive if you need a sample.

Search on VBA (or VBE), password and sendkeys.