Macro to lock VBA project

[Klemen25]

Hello

Is it possible to have a macro that will:
1. under VBA project properties lock project for viewing
2. open input box to input password to view project properties.
3. save file /or prompt to save as.


So in other words after you open vba project and play woth macros,
work on file etc, one could just click a button and a input box to
input password to lock VBA project would be opened. Afeter you input
it the input box closes and saves the file or prompts save as if it is
not saved yet?

I tried to google it and record it but no luck...

Anyone?
Thank you

 

[Dave Peterson]

Excel's VBA doesn't support this.

The closest you could get is to use Sendkeys and that's not reliable.

 

[Klemen25]

Ok- tanks!