How to create an open workbook password via VBA?

**eroock** · 03-15-2013, 10:47 PM

Hi,

I want to password-encrypt my workbook with VBA, so that it prompts for a password on next opening. I know it can be done with:

ActiveWorkbook.SaveAs Filename:="FilePath", Password:="password"

but I don't want to save the file at this point. Basically I need the following function in code
http://www.reset-password.net/create...xcel-2007.html

Any idea?

**Toonies** · 03-16-2013, 03:39 AM

hi have a look at this

http://technologytraining.psu.edu/node/234

or this

http://office.microsoft.com/en-gb/ex...010226798.aspx

**eroock** · 03-16-2013, 06:16 AM

That doesn't help. I want to do it using a macro.

**Toonies** · 03-16-2013, 01:24 PM

Ok try this, it may help you.

Username is Toonies

Password is abcd

Password2.xlsm

you can change them as you wish.
It has an Admin page wich is hidden

If you need any further help let me know

Toonies