VBA to type a text in Windows (Excel)

Dear Expert,

I open a Excel file, forced to type in password in the pop-windows.

Passwords had to be input twice.

It is changed once a year.

Is it possbile to set auto-text message (password) in VBA ?

Press the marco button and as if typing the password in pop-up windows.

Can Excel VBA do that?

Thanks

Elton

Hi There,

Im not sure if I understood your query correctly. Did you mean that a macro should input your password automatically when the file prompts for a password?




Thanks,

Bonny Tycoon


**If I was able to help please click the small star icon at the bottom left of my post **