One line of code messed up!

  • Thread starter Thread starter scrabtree23
  • Start date Start date
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
 
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)
 
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.
 
Back
Top