One line of code messed up!

S

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
 
B

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)
 
T

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.
 
Top