Is there a way to use VBA to set up a VBA password in another workbook?

E

Excel 009

Hi everyone,

Is there a way to use VBA to set up a VBA password in another workbook?



I know there is way to put VBA module and sub procedure into another
workbook using VBA, but can I password protect them using VBA as well?


AS
 
T

Tom Ogilvy

Only using sendkeys and that could be unreliable. I have never tried to do
it, but some have previously posted such code in this group. so you could
search groups.google.com archive for this newsgroup.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to bypass password when pasting FROM a protected workbook 3
Is there a way to use VBA to set up a VBA password in another workbook? 2
Excel VBA Project Has Protection? 2
Setting up Solver reference in a protected VBA project 1
Pulling data from one workbook to another one using VBA 0
unlock vba password using another vba code 2
Programmaticlly sign and password protect a VBA Project in Excel 2 6
Excel prompts for VBA password when opening 5

Top