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.