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)

"scrabtree23" wrote in message
...
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