Alt + F11 - Enter Password 'abc'
 

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


--
Farah
------------------------------------------------------------------------
Farah's Profile: http://www.excelforum.com/member.php...o&userid=27779
View this thread: http://www.excelforum.com/showthread...hreadid=479700

Alt + F11 - Enter Password 'abc'
 

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


--
Leith Ross
------------------------------------------------------------------------
Leith Ross's Profile: http://www.excelforum.com/member.php...o&userid=18465
View this thread: http://www.excelforum.com/showthread...hreadid=479700

Alt + F11 - Enter Password 'abc'
 

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

Alt + F11 - Enter Password 'abc'
 

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

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