Macro to open password protected workbook

Hello,

I am hoping you are able to assist.

I am trying to write a macro to open a workbook. The file requires a password to open it - this is my own workbook and i know the password.

Is it possible to write a code (similar to Workbooks.Open Filename etc) that allows you to enter the password automatically. I need to open the file when the macro runs, but not allow others to know the password.

I hope this makes sense.

Many thanks in advance,

Chris