View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default One line of code messed up!

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.

--
Regards,
Tom Ogilvy

"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