Alt + F11 - Enter Password 'abc'

[Farah]

Hi,

Can i please have a macro, which will do the followings:

- Go to Alt + F11
- Type my Workbook Password (i.e. 'abc')

i think with the sendkeys method.

Kind Regards,
Farah

[Leith Ross]

Hello Farah,

I am not sure I understand what you want to do. Do you want to create a macro to open a password protected workbook automatically? Why do you want to open the Visual Basic Editor (Alt + F11)? Let me know so I can help.

Sincerely,
Leith Ross

[Farah]

Thank you for your post.

I actually got what i was looking for.

Can you please see if i can get some help on Deleting all VB codes in my workbook with a code ?

Thank you.
Sana.

[Norman Jones]

Hi Sana,

See Chip Pearson's VBE programming page at:

http://www.cpearson.com/excel/vbe.htm

See particularly the section entitled:

'Deleting All VBA Code In A Project'.

Note, however, Chip's instructions (at the top of the page) on setting a
reference to the Microsoft Visual Basic For Applications Extensibility
library.


---
Regards,
Norman



"Farah" <[email protected]> wrote in
message news:[email protected]...
>
> Thank you for your post.
>
> I actually got what i was looking for.
>
> Can you please see if i can get some help on Deleting all VB codes in
> my workbook with a code ?
>
> Thank you.
> Sana.
>
>
> --
> Farah
> ------------------------------------------------------------------------
> Farah's Profile:
> http://www.excelforum.com/member.php...o&userid=27779
> View this thread: http://www.excelforum.com/showthread...hreadid=479700
>