Fill in password with macro

[vin1]

Hi,

I cant figure out how to fill in a password with VBA when a workbook is openend.
The idea is when a workbook is openend the macro's should fill in the password to unlock it.

I want this because when the user does not have macro's turned on they wont gain acces acces to the workbook and thus they need a password to enter. amd so when macro's are turned on. the password will be automaticly filled in and the user wont see the password screen coming up.

anybody may know how to do this or suggest how to get this ressult?

grz

[Richard Buttrey]

Hi,

Why use VBA? Just use Excel's normal password security.
i.e. in 2003: Tools, Protection, Protect Workbook and enter the relevant password.

Also note that Excel passwords are not foolproof. There are various macros around that will break them.

Regards

[abousetta]

Hi,

This is the simplest approach I could think of. Begin with your workbook and worksheets locked and put this macro in a standard module

Please Login or Register  to view this content.

and this one in ThisWorkbook Object

Please Login or Register  to view this content.

It seems to work for me. Tell me if it works for you.

abousetta

[vin1]

I think i did not made the point clear enough.


When a user turns of macro's i want to be sure they cannot enter the workbook (unless they type in a password or so)

Because when the macro's are turned off, users may not use the workbook because they may destroy the system.

So my idea was to put a password on it (Excel normal password not VBA password)
and if macro's are on an event must be triggered that fills in the password.



I think its the easyest way is when he asks for the password, an event gets triggered and fills in this password. so when macro's are off the event won't be triggered and the user may not join, unless they know the password.

So if macro's are on the user wont see the password screen and simply can start doign stuff in the file without breaking anything cause events will protect the file.

[dominicb]

Good afternoon vin1

As you know, you cannot force users to enable macros, but you can use VeryHidden sheets, and only make them visible via macros - which therefore have to be enabled. This technoque is discussed here by Ken Puls, along with some sample code.

HTH

DominicB

[vin1]

thanks, this should do it.